Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am getting the error:

Table 'feed_data' is marked as crashed and should be repaired

So I run REPAIR TABLE feed_data (repeatedly) and get the following result:

| Table          | Op     | Msg_type | Msg_text                                                      |
| mydb.feed_data | repair | Error    | Table 'feed_data' is marked as crashed and should be repaired | 
| mydb.feed_data | repair | status   | Table is already up to date                                   | 
2 rows in set (0.06 sec)

The table still shows as crashed. Why won't the table repair when I run the repair table command? What else can I do to repair the crashed table?

share|improve this question
up vote 2 down vote accepted

Shutdown the DB and use myisamchk.

share|improve this answer
I once had to export that data, the rebuild the table and reimport the data because myisamchk didn't work. – lilott8 Mar 4 '11 at 18:02

You may also want to have mysql perform automatic repairs each time you restart mysql

Just add this to the [mysqld] section of /etc/my.cnf


Here is a more detailed explanation of the options as explained in the book

enter image description here

MySQL 5.0 Certification Study Guide Chapter 30 Section 30.5 Pages 444,445

Here are the options for myisam-recover

  • DEFAULT for the default checking

  • BACKUP tells the server to make a backup of any table that it must change

  • FORCE causes table recovery to be performed even if it would cause the loss of more than one row of data

  • QUICK performs quick recovery: Tables that have no holes resulting from deletes or updates are skipped

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.