Backup and restore mysql database

Make backup

mysqldump -u user -p password  | gzip > outputfile.sql.gz

Restore

gunzip < outputfile.sql.gz | mysql -u user -p password databasename

adapted from http://www.ducea.com/2006/10/28/compressing-mysqldump-output/