Home > mysql > Database table repair

Database table repair

Few minutes ago, one of our mysql database table (it’s really a big table) was crashed.
So to repair this i login that server and excute

repair table tablename

But the repair process failed, and i got this output.

test.t1 | repair | error | 13 when fixing table |
| test.t1 | repair | status | Operation failed |

Then i start searching on google. After passing some time i found the reason. Mysql can’t repair that table as there is a trigger on this table. So i tried to drop the trigger

drop trigger triggername

no luck, mysql can’t drop the trigger, as the table was crashed 🙁

Now i studied more and more. At last i got the solution 🙂

REPAIR TABLE tablename USE_FRM

Now the table repair complete successfully. Thanks to Allah as i got the solution in time:)

Views :239519
Categories: mysql Tags: , ,
  1. tsabnam
    August 12th, 2007 at 02:56 | #1

    Good job lavlu 🙂

  2. August 12th, 2007 at 10:23 | #2

    thats great!

  3. MB
    September 22nd, 2007 at 03:00 | #3

    Thanks… saved me butt..

  4. January 16th, 2011 at 22:41 | #4

    Hi there. Thank you so much for sharing an awesome forum like this.
    it’s amazingly very useful. hope to learn more from you.
    I have my own blog called strange as.. מגנטים לאירועים.There you can see good things

  1. No trackbacks yet.

%d bloggers like this:
54 queries in 0.409 seconds