Feb
20 2009
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)















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.
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.
September 16th, 2009 at 2:36 am
Thanks! it worked fine.
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.