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


From time to time MySQL corrupts itself. This message means that your table needs repair, however, the option for repair through the PHPMyAdmin interface is not available. 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".
 
Therefore, you need to open a terminal or ssh (Putty) and run the following commands:
 
cd /usr/local/MySQL/var/ragnarok  (where "ragnarok" is the one you're trying to fix)
myisamchk --safe-recover char  (where "char" is the table you are trying to fix)
 
This will repair the table in safe mode or your table will be fixed in a few minutes!
 
 
  • phpmyadmin, phpmyadmin in use, mysql in use
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Guide how to download Ragnarok Game Client Installer

1. Download the game client Installer. option a). Lite Installer: The lite installer is only...

How to Access your Folders(Linux/Centos) using WinSCP

Guide on how to access the folders in your vps linux! This is the easiest way, First make sure...

How To Start, Compile, and Stop Your Server Using Putty

Download Putty first from this link Click me to download!Note: Please follow the tutorial by...

How to Access your Folders(Linux/Centos) using WinSCP

Guide on how to access the folders in your vps linux! This is the easiest way, First make sure...

Powered by WHMCompleteSolution