Knowledgebase

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

Add to Favourites    Print this Article

How can I RESTORE a MySQL database from the command line? (Views: 2272)

How do I clear the exim sendmail statistics on CPanel / WHM ? (Views: 8434)

What are the exact specs of your hardware? (Views: 2605)

What is MySQL? (Views: 2728)

How to update CPanel/WHM from shell command line (SSH) ... (Views: 28236)