How to repair a broken database?

MySQL queries or tables stop working

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 contact HostGator via live chat, phone, or email support@stretchhost.com with the details.

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

Before creating Addon domains

Addon Domains are handled like subdomains as far as the server is concerned, but to the outside...

How to log into cPanel

If you recently purchased a new account with StretchHost, you should type the following...

How do I create or delete a MySQL Database?

Create: If you are using any type of PHP software or keeping a collection of records which need...

How to change permissions of a file (CHMOD)?

Permissions can be very important when it comes to hosting your website. Permissions can allow...

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

Powered by WHMCompleteSolution