How to repair a database?

If you get an error which says that your database has crashed and needs to be repaired, then you should easily fix this in cPanel.

Even if you are getting a another error "supplied argument is not a valid" or "table attribute does not exist", Try these steps it may fix the problem:

  1. Login to cPanel and click MySQL Databases.
  2. Under Modify Databases, look for the drop-down called "Check DB".
  3. Select the database name which is having trouble.
  4. Click the Check DB button.

This should tell you the cause of the problem. If the problem is identified as "marked as crashed", then proceed.

  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.

*This may or may not solve the actual issue, this really depends on how you have created your database as well.

Was this answer helpful?

Related Articles

How do I import ,SQL file to PHPmyadmin?

1.  First log in to your cPanel 2.  Click MySQL  Databases 3.  Click phpMyAdmin 4.  Click...

How do I backup my MySQL Database in cPanel?

1.  First log in to your cPanel 2.  Click MySQL  Databases 3.  Click phpMyAdmin 4.  Click...

How to create an empty MySQL database in cPanel?

1. First log in to your Cpanel 2. Click MySQL Databases 3. Create a user by typing any username...