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:)
number of view: 1020Popularity: 16% [?]
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
I am S. M. Ibrahim lavlu aka lavluda working as web application developer, SEO, server security and optimization, apps scaling consultant from dhaka, bangladesh. On my free time i like to pass my time for opensource projects.




Good job lavlu
[Reply]
thats great!
[Reply]
Thanks… saved me butt..
[Reply]