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?

 Print this Article

Also Read

How do I import ,SQL file to PHPmyadmin?

1.  First log in to your Cpanel 2.  Click MySQL  Databases...

How to import a database to cPanel?

Create a new database in cPanel Go to phpMyAdmin Click the new database name in the top left...

How do I backup my MySQL Database in cPanel?

1.  First log in to your Cpanel 2.  Click MySQL  Databases...

What version of MySQL does Philwebhosting.Net is running?

We run the latest stable version of MySQL

How to create an empty MySQL database in cPanel?

1. First log in to your Cpanel 2. Click MySQL Databases 3. Create a...

Powered by WHMCompleteSolution

Language: