Problem with mysql

[krissanto]

I'm experiencing a problem with mysql, there's a message error on windows server event viewer since date October 3rd, before it was fine my cacti working normally.

These are the message error :

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table '.\cacti\poller_item' is
marked as crashed and should be repaired

How do i solved these problem ?

[Linegod]

Google 'repair crashed mysql table window' and you will find your answer. It is not Cacti specific

[krissanto]

i used these command, which i got from http://stackoverflow.com/questions/2296 ... phpmyadmin

mysql -u username -p
mysql> use dbname;
mysql> repair table tablename;

when i type "use mysqld" i got an error message unknown database

[krissanto]

Solved... After looking for answer on this thread http://forums.cacti.net/viewtopic.php?f ... 5&start=15

Just type "mysqlcheck -u root -p --repair cacti" on command prompt.

1 more question if i may ask, why can't repair database mysqld.pdb ? it's keep telling me that "error opening database"

[TheWitness]

In MySQL 5.1 there is a my.cnf setting to autorepair MyISAM tables. You need to set it and then restart the MySQL service. Please google the setting. Post your finding here for the rest of the community.

Thanks,

TheWitness