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)

4 Responses to “MySQL table corrupt & repair”

  1. repair MySQL said:
    March 19th, 2009 at 5:26 pm

    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.

    1. David said:
      June 29th, 2009 at 3:10 pm

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

      1. Kumar Keswani said:
        September 16th, 2009 at 2:36 am

        Thanks! it worked fine.

        1. SugarUser said:
          March 8th, 2010 at 1:07 pm

          I am novice command line user (couldn’t USE DB, wrong permissions were setup etc) However, I used the repair SQL code, in PhpMyAdmin – and it has worked perfectly, thanks.

          Leave a Reply