mysql 备份命令

mysqldump -uroot -p --default-character-set=utf8 --opt --master-data=1 --single-transaction --flush-logs db_name > db_name_%date:~2,2%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%%time:~9,2%.sql

 

 

mysqldump -uroot -ppassword--default-character-set=utf8 --opt db_name > db_name_%date:~2,2%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%%time:~9,2%.sql