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