mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename