How to repair a broken database

MySQL queries or tables stop working

If you get an error which says, "so-and-so is marked as crashed and needs to be repaired," then you can easily fix this in cPanel.

Even if you are getting a different kind of error like "supplied argument is not a valid" or "table attribute does not exist", then you can use this test to try and fix the problem.

  1. Login to cPanel and click MySQL Databases.
  2. UnderĀ Modify Databases, look for the drop-down called "Check DB".
  3. Select the database name which is having trouble.
  4. Click the Check DB button.

This should reveal the cause of the problem. If the problem is "marked as crashed", then proceed.

  1. Go back to MySQL Databases.
  2. UnderĀ Modify Databases, look for the drop-down called "Repair DB".
  3. Select the database name which is having trouble.
  4. Click the Repair DB button.
  5. Once complete, reload your web site.

If the error is not gone, please contact GoMedia - support@gomedia.com.au with the details.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I password protect directories?

To password protect directory: Note: At this time, cPanel can only protect directories, not...

phpMyAdmin

phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases...

Copy Entire Database or Rename Database

Is there a way for me to copy an entire database in cPanel? Go to cPanel > MySQL Databases...

How to import your MySQL database

How can I import a database? Go to phpMyAdmin Click the new database name in the top left...

Creating a URL redirect

WARNING Never create a redirect for domain.com to www.domain.com or from domain.com to...