RSS
people

MySQL table corrupt & repair

Share/Save/Bookmark

Recently I am trying to dump a customer MySQL database to a SQL file & restore to another server.
An error occur during the dump process.

The error mention that one of the table in the database is crashed & repair required.
Then I try to login into MySQL server & use the particular database & execute the “DESC” command.
The result is “ERROR 145 (HY000): Table ‘./XXXXXXX/tracker’ is marked as crashed and should be repaired”

mysql> desc tracker;
ERROR 145 (HY000): Table './XXXXXXX/tracker' is marked as crashed and should be repaired
mysql> check table tracker;
+----------------------+-------+----------+----------------------------------------------------------------------------+
| Table                | Op    | Msg_type | Msg_text                                                                   |
+----------------------+-------+----------+----------------------------------------------------------------------------+
| XXXXXXX.tracker      | check | error    | Table './XXXXXXXXX/tracker' is marked as crashed and should be repaired |
+----------------------+-------+----------+----------------------------------------------------------------------------+
1 row in set (0.03 sec)

Then I try to execute the repair command for the table & it solve the problem.

mysql> repair table tracker;
+----------------------+--------+----------+------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                 |
+----------------------+--------+----------+------------------------------------------+
| XXXXXXXXXXXX.tracker | repair | warning  | Number of rows changed from 0 to 1151697 |
| XXXXXXXXXXXX.tracker | repair | status   | OK                                       |
+----------------------+--------+----------+------------------------------------------+
2 rows in set (2 min 7.91 sec)

3 Responses to “MySQL table corrupt & repair”

  1. repair MySQL Says:

    That’s good that it recover your database, but some times this kind of corrections in MySQL doesn’t able to repair corrupted MySQL database files, then MySQL repair software is required.

  2. David Says:

    Sometime the repair query doesn’t repair the database. During that time you need to use MySQL recovery Software.

  3. Kumar Keswani Says:

    Thanks! it worked fine.

Leave a Reply