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.

1 year 50 weeks ago   Tags:


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.