Filed under:

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

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

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read