How to Repair a Broken Database | HostGator Support
  1. Knowledge Base
  2. >
  3. Results
  4. >
  5. How to Repair a Broken Database

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.

How To Check Databases via MySQL Databases

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 in to cPanel.
  2. Look for the Databases section, then click on the MySQL Databases icon.

    MySQL Databaess

  3. Under Modify Databases, select the database name you're having issues with from the Check Database drop-down menu.

    phpMyAdmin - Check Database

  4. Click the Check Database button.

How To Repair Databases via MySQL Databases

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

  1. Go to the MySQL® Databases section.

    MySQL Databaess

  2. Under Modify Databases, select the database name you're having issues with from the Repair Database drop-down menu.

    Repair Databases

  3. Click the Repair Database button.
  4. Once done, reload your website.
Need further assistance? Please contact us via phone or chat so we can assist!