使用环境是,在测试服务器下,每天定时备份当天的数据,然后还原之前的原始数据库;
还原是为了:做到每天恢复测试环境,第二天又可以重复操作,
备份是为了:如果有些数据更改后,需要已这一份为准,可以把数据保存下来,避免定时恢复后,遗忘。。。
备份:
cd C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin mysqldump -uroot -p123456 test > D:\test/test%Ymd%.sql exit
还原:
cd C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin mysql -uroot -p123456 test < D:\test/test.sql exit
参考的:
备份 set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%" md "D:\databackup\%Ymd%" "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --opt -Q databasename -uroot -p123456 > D:\databackup\databasename%Ymd%.sql @echo off mshta vbscript:msgbox("mysql backup successed!!!",6,"mysql backup")(window.close) 恢复 "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" -uroot -p123456 ensjp < D:\databackup\databasename.sql @echo off mshta vbscript:msgbox("mysql restore successed!!!",6,"mysql restore")(window.close)
原文:https://www.cnblogs.com/zxh06820/p/12566364.html
如果您也喜欢它,动动您的小指点个赞吧