Recently when i optimized some mysql tables from phpmyadmin, some of the tables were “locked” and showed as “in use” on phpmyadmin. The tables could not be used, read, etc. So the script was stopped working.
I have tried to repair / check / analyze from phpmyadmin but i couldn’t repair it.
So i tried to repair the mysql tables from SSH.
Go to your database directory. Usually it is located on
So use this command first
Next, use this command
myisamchk --safe-recover --force YOUR_TABLE_NAME
And the MySQL table should be repaired now.