MySQL Table says IN USE, but table will not repair in phpmyadmin.
From time to time mysql corrupts itself.
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;
[root@server~]# cd /var/lib/mysql/DATABASE (where DATABASE is the one you’re trying to fix)
[root@server~]# myisamchk –safe-recover TABLE (where TABLE is the table you are tring to fix)