mysql 备份和恢复的两条命令

压缩备份：

1.mysqldump -h localhost -u root -p dbname | gzip > dbname.sql.gz

 

压缩恢复:

1.gunzip < dbname.sql.gz | mysql -h localhost -u root -p