MySQL的備份及還原：使用mysqldump及gzip

Backup:
mysqldump [database_name] -u root -p | gzip > backup.sql.gz

Restore:
如果沒有database
mysql -u root -p
mysql>create database [database_name];
Query OK, 1 row affected (0.01 sec)
mysql>exit
Bye

gunzip backup.sql.gz
mysql [database_name] -u root -p < backup.sql