mysql的备份与恢复

备份

mysqldump -uusername -ppassword databasename |gzip >zipname.zip

恢复

gunzip -c < zipname.zip|mysql -uusername -ppassword databasename