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

From time to time mysql corrupts itself.  This can normally be fixed using the KB Article here: http://portal.my-tss.com/knowledgebase.php?action=displayarticle&id=194

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;

cd /var/lib/mysql/DATABASE  (where DATABASE is the one you're trying to fix)

myisamchk --safe-recover TABLE  (where TABLE is the table you are tring to fix)

This will will repair the table in safemode, and SHOULD result in success.


reviewed:  10/27/2016

  • Email, SSL
  • 35 Users Found This Useful
Was this answer helpful?

Related Articles

How do I find my root password?

1) Log into your billing account: https://portal.my-tss.com/clientarea.php 2) Click on the...

How to generate a CSR in WHM

You would like to purchase or transfer an SSL certificate but need a CSR to do so. Here's how to...

Changing ip addresses

To move an account from one ip to another in WHM:1) Log into WHM using root login details....

-DELETE How to downgrade MySQL from Version 5 to Version 4

If you've upgraded your MySQL Software to the newest version but for whatever reason need to...

How to disable Recursive DNS Lookups

A very common PCI Issue is related to the DNS servers.  In order to be PCI Compliant you must...