Small blog about system administration.

How to check and repair all databases in MySQL

Default command:

#mysqlcheck -uroot -p<root-password> --auto-repair --check --optimize --all-databases

For Parallels Plesk:

#mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --check --optimize --all-databases


Keep it simple :-)

2 comments :

Post a Comment