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: 2205)

How do I OPTIMISE all MySQL databases on my virtual / dedicated server? (Views: 1942)

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

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

What are the "Astutium Support Access" or "Astutium Customer Access" SSH Keys? (Views: 7220)