How do I REPAIR all MySQL databases on my virtual / dedicated server?

Repairing All Databases

You can repair your databases using mysql as the root user with the mysqlcheck utility...
from an ssh prompt as root type
mysqlcheck -u root -p --all-databases -A --auto-repair

Note:
This will take some time and cause significant load to your server and should only be done if your mysql log shows that multiple databases have errors

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

How do I stop Cpanel reporting /usr/bin/crontab permissions are wrong. Please set to 4755.

If you get this message in CPanel when adding/ediiting/viewing the cron jobs ......

How do I force Statistics (Webalizer and AWstats) to run on Plesk Servers ?

Updating Webalizer and AWStats on Linux Plesk Servers from SSH The plesk control panel is...

How much is HELM ? What Helm licences do you offer ?

Web Host Automation (HELM Authors) sold the control panel rights and code some years ago to...

How to Backup your MySQL DB databases

Backup command for mysql databases For those looking to get a regular backup of your MySQL...

How do I create a MySQL database in Cpanel ?

MySQL databases can be created through the cpanel control panel: Login to your control panel...

Powered by WHMCompleteSolution