MySQL Cheat Sheet

Posted Thu, 05/18/2006 - 9:00pm

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

• PHP / MySQL