World of *Nix

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:)

Related posts:

1. how to move your php development environment to linux (Debian/Ubuntu) Nowadays, lots of php developers are thinking to move their...

Related posts brought to you by Yet Another Related Posts Plugin.