MySQL Tips

Portal Home > Knowledgebase > General > MySQL Tips

For hosting clients with ssh (command line) access, you may follow these steps:

Backup your /var/lib/mysql dir and then run this command:

find /var/lib/mysql/* -type f -name *.MYI -exec myisamchk {} \;

This will repair all your mysql DB tables

***

Also you can run:

mysqlcheck --all-databases -r
mysqlcheck --all-databases -a
mysqlcheck --all-databases -o

First repairs the databases
Second Analyzes the databases
Third Optimizes the databases