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

Does Philwebhosting.Net allow Remote MySQL access in cPanel?

Yes, to manage your databases remotely you will need to add an "access host" via the MySQL...

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 import ,SQL file to PHPmyadmin?

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

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 backup my MySQL Database in cPanel?

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

Powered by WHMCompleteSolution

Language: