Loading...

Knowledge Base

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. There are two ways to access your cPanel.
    • Option 1: Access your cPanel directly.
    • Option 2: Access your cPanel via your Customer Portal.
      1. Log in to your Customer Portal.
      2. Click Hosting in the left-side menu.

        Customer Portal - Hosting menu

      3. If you have a single hosting package in your account, scroll down to the Quick Links section.


        If you have multiple hosting packages in your account, locate the hosting package you want to manage on the Hosting Packages page, then click its Manage button.

        Hosting tab - Manage button

      4. Under the Quick Links section, click the cPanel button.

        Hosting menu - Quick Links - Launch cPanel

  2. Within cPanel, 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," proceed with the steps below.

  1. Within cPanel, 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 chat so we can assist you!
Did you find this article helpful?

 
* Your feedback is too short

Loading...