How to repair a broken database

If you get an error which says, "so-and-so is marked as crashed and needs to be repaired," then you can easily fix this in cPanel.

Even if you are getting a different kind of error like "supplied argument is not a valid" or "table attribute does not exist", then you can use this test to try and 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 reveal the cause of the problem. If the problem is "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.

If the error is not gone, please open up a ticket with our Support Department for assistance.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to upload to an Addon or Subdomain

Option 1Step 1: In a FTP client enter this information. Host = add on domain name User...

Backup file types - cPanel

So, you have a backup file, but you need to know what type of backup it is so you can know what...

Apache Error Logs

When you check the error logs, you can see many things.Some things you can ignore:File does not...

How do I create and delete a cron job?

Cron Jobs run scheduled tasks at specific times. This is good to set up automated maintenance and...

How to download a home directory backup

Backups are very important part of maintaining a website. It is important to backup your files on...