mysqldump: Error 1194: Table 'boost_cache_relationships' is marked as crashed and should be repaired when dumping table



Hi,

I am taking backup of my mysql database using mysqldump:

mysqldump -uroot -ppass drupal6 > drupal.sql

and it shows that my boost_cache_relationships table in drupal is crashed and gives following error:

mysqldump: Error 1194: Table 'boost_cache_relationships' is marked as crashed and should be repaired when dumping table

Please help.



This means that you need to repair your table. Connect to your mysql table and then repair the table as follows:

Step 1: Connect and go to mysql shell:

mysql -uroot -ppass drupal6

Step 2: Use "Repair Table" command on mysql shell as follows:

mysql> repair table boost_cache_relationships;

This should fix it.