Knowledgebase: MySQL
How can I fix a MySQL table that is showing as 'In Use'
Posted by - NA - on 2006-10-16 12:59:48 PM

If a script has failed in some way, it may have left your MySQL database in an inconsistent state with various tables being reported as "IN USE" or as "ERROR". To fix this problem, you need to "Repair" the table.

  1. Login to your cPanel control panel (either via http://www.example.com/cpanel where example.com is your domain name or via http://www.easyinternetsolutions.co.uk/conpanel/login )

  2. Click on the "MySQL Databases" button and scroll down the page and click on "phpMyAdmin" at the bottom of that page.

  3. From the left hand menu, select the database you are having problems with.

  4. Select/ticket the checkbox next to the table that is reporting the problem.

  5. Scroll down and in the "With selected:" drop down box, select "Repair table".

  6. This should automatically fix your MySQL table(s).

(10 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).