How to Repair a Broken Database

If you encounter database errors, such as

cpaneluser_database is marked as crashed and needs to be repaired.

or other issues affecting your website, you can often resolve them directly within cPanel. Using the built-in MySQL® Database tools, you can quickly check and repair your database to restore normal functionality. This process helps identify common database issues and ensures your website data remains accessible and working properly.

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.

Log in to cPanel.
Within cPanel, look for the Databases section, then click on the MySQL Databases icon.
Under Modify Databases, select the database name you're having issues with from the Check Database dropdown menu.
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 steps below.

Within cPanel, go to the MySQL® Databases section.
Under Modify Databases, select the database name you're having issues with from the Repair Database dropdown menu.
Click the Repair Database button.
Once done, reload your website.

Need further assistance? Please contact us via phone or chat so we can assist you!

Did you find this article helpful?