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!
- What is the difference between a VPS and Web Hosting (shared)?
- How to reduce the number of inodes/files on cPanel account?
- What are the advantages of a VPS?
- cPanel: Unactive License File
- Command line bandwidth monitors for Linux
- Why is my VPS constantly crashing?
- What is guaranteed and burst memory (RAM)?
- How to change your Web Hosting or CPanel password?
- How do I know what server I am on?
- Changing Server Hostname
- One-Click WordPress
- Check the RAM Usage in Linux
- What is a VPS?
- Our VPS Hosting Test IP
- How to Access your Folders (Linux/Centos) using WinSCP?
- MySQL Table says IN USE, but table will not repair in PHPMyAdmin
- How to change your VPS and phpMyAdmin password?
- How to Fix PHPMyAdmin Error “Fatal error: Allowed memory size of 132218712 bytes exhausted (tried to allocate 11641294 bytes)”?
- Changing Time Zone
- How to Traceroute and Ping your VPS IP Address Connection using WinMTR?