mysqldump -h localhost -uroot -ppassword db_name | gzip > db_name.sql.gz
mysql -h localhost -u root -ppassword db_name < db_name.sql