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

This Comment will be submitted for moderation and will not be accessible to other users until it has been approved.


28 points

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 39 weeks ago   Tags:


1 point

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.

Anonymous's picture
Created by Anonymous

Post Comment

  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.