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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

WordPress pointing home URL to subdirectory

Pointing your home site's URL to a subdirectory In some cases, you may have a WordPress site...

How to log into cPanel

cPanel is a web hosting account management tool available on all Digicom Linux hosting plans,...

Change cPanel Password or recover lost password

Requesting a New cPanel Password If you have lost or forgotten your cPanel password, you can...

Location of Script Configuration Files

Location of Script Configuration Files These paths are relative to the root of the script, not...

Connect to MySQL Database

How to Connect to the MySQL Database In order for your MySQL database to work as intended, it...

Powered by WHMCompleteSolution