MySQL Cheat Sheet

SSH repair and optimize all MySQL databases: # /usr/bin/mysqlcheck --repair --all-databases --password=xxxxxx # /usr/bin/mysqlcheck --optimize --all-databases --password=xxxxxx Upgrade/Downgrade to MySQL...

SSH repair and optimize all MySQL databases:

# /usr/bin/mysqlcheck –repair –all-databases –password=xxxxxx

# /usr/bin/mysqlcheck –optimize –all-databases –password=xxxxxx

Upgrade/Downgrade to MySQL 4.x:

backup database:

# cd /root

# /usr/bin/mysqldump –create-options –compatible=mysql40 –all-databases –force –user=root –password=xxxx > backup.sql

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.