Linux command find and repair crashed tables

[postcd]

Hi, i got this message from my php script:

Table './cashbb_vb/searchcore_text' is marked as crashed and should be repaired

So i want to ask how i can prevent site downtimes and what is the command i need to run on cronjob to check all mysql databases, find such buggy tables and repair them automatically?

 

[Rodrigo]

Try with one of these commands:

1)

mysqlcheck -c  -u root -p --all-databases

2)

 mysqlcheck -c  -u root -p --databases <dbname>

Documentation:

http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

 

[postcd]

Thanks for contribution Rodrigo, but that command dont works to fix that table, this is what it return:

cashbb_vb.searchcore OK
cashbb_vb.searchcore_text
warning : Table is marked as crashed
status : OK
cashbb_vb.searchgroup OK
cashbb_vb.searchgroup_text OK
cashbb_vb.searchlog OK
cashbb_vb.session
note : The storage engine for the table doesn't support check

MySQL Error : Incorrect key file for table './cashbb_vb/searchcore_text.MYI'; try to repair it

 

[mavankhang]

Try with one of these commands:

1)

mysqlcheck -c  -u root -p --all-databases

2)

 mysqlcheck -c  -u root -p --databases <dbname>

Documentation:

it is , like