1、备份:mysqldump -u user -p --opt database >backfile.sql
2、还原:mysqladmin -u user -p create target_database
mysql -u user -p target_database < backfile.sql
2、还原:mysqladmin -u user -p create target_database
mysql -u user -p target_database < backfile.sql