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

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...

How to export database in cPanel?

Go to existing database in phpMyAdmin Click Export at the top Leave the settings as they are,...

How do I import ,SQL file to PHPmyadmin?

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

How do I backup my MySQL Database in cPanel?

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

Powered by WHMCompleteSolution

Language: