How to Repair a Broken Database

If you get the following error, it can easily be fixed from within cPanel:

cpaneluser_database is marked as crashed and needs to be repaired

Checking the Database

Even with different kinds of errors such as "supplied argument is not a valid" or "table attribute does not exist," the following steps can be used with this built-in cPanel test to try fixing the issue.

  1. Log into cPanel and navigate to the Databases section.
  2. Click on the MySQL Databases icon.
  3. Under Modify Databases, look for the drop-down menu called Check DB.
  4. Select the database name which is having trouble.
  5. Click the Check DB button.

Repairing the Database

The checking process should reveal the cause of the problem. If the problem is "marked as crashed," then proceed with the steps listed below:

  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 HostGator via phone or live chat; or submit a ticket to our Support department with the details.

cPanelcPanel is a popular web hosting control panel that helps you manage your hosting account and assists you in creating web sites, managing e-mail addresses, & installing applications to a server.

cPanel is available on all HostGator Linux hosting plans, including Shared Hosting, Reseller Hosting, VPS and Linux Dedicated Servers.