mysql备份和恢复命令

mysqldump --opt --user=USERNAME --password --host=SERVERNAME DBNAME > FILENAME

mysql -u USERNAME -p -h SERVERNAME DBNAME < FILENAME