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!
 
 
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

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 traceroute your VPS IP?

How to Use the Traceroute Command Traceroute is a command which can show you the path a...

Custom Items

Alternative Video Tutorial: https://youtu.be/cV11LJ0VDakFirst, let's take a look at the item_db...

Ragnarok Developer Tools

Hercules Forumhttp://hercules.ws/board/rAthena Forumhttp://rathena.org/board/GRF ToolBest GRF...

Tips for Ragnarok Newbie Developer

  1. Setup your Offline Server and practice:...