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 dropdown 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," then proceed with the steps listed below.

  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 dropdown menu.

    Repair Databases

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