MySQL Table says IN USE, but table will not repair in phpmyadmin

Under some situations however, no matter how many times you run a REPAIR on the table, the table still returns IN USE and what's worse is that the system says the table is "already up to date".

If you have shell access, here's what to do;

cd /var/lib/mysql/DATABASE (where DATABASE is the one you're trying to fix)

myisamchk --safe-recover TABLE (where TABLE is the table you are tring to fix)

This will will repair the table in safemode, and SHOULD result in success.

 

Bài viết này tốt? 30 Users Found This Useful (92 Votes)