Repairing MySQL databases

From time to time, due to various factors, databases can become corrupt, causing websites not to function properly anymore. Fixing this, hwoever, is not a difficult task and can easily be done via cPanel.

In order to do this, you would need to follow this procedure:

  • Log into your cPanel account.
  • Go to MySQL Databases
  • Under Modify, use 'Check DB'
  • Select the database you want to check for errors
  • Click 'Check DB'

If an error is found, you just have to use the 'Repair DB' option, which would attempt of getting rid of it and repairing your database.

Please note that before doing this, it is recommended that you do a backup of the database.

  • mysql, database, repair
  • 83 Users Found This Useful
Was this answer helpful?

Related Articles

Certificate warning when accessing cPanel

When you access cPanel or WHM through the secure connection and get a warning in your browser...

How to fix "Invalid cPanel License" error

After logging into WHM you may come across an error message that says "Invalid cPanel License"...

How to enable SPF and DKIM for your account

Email authentication is important for proper email deliverability and help to prevent your emails...

How to add an IP address in WHM

When an ip address is routed to your server you'll need to add it in your WHM control panel...