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 do I create a MySQL database in DNP ? (Views: 2215)

How do I move a MySQL Database from one host to another using phpMyAdmin ? Backup and Restore using phpMyAdmin. (Views: 16056)

How do I Access MySQL Using SSH on Plesk Servers ? (Views: 7609)

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

How can I BACKUP a MySQL database from the command line? (Views: 3156)