1 @echo off 2 :start 3 CLS 4 5 set dt=%time:~0,2% 6 if %dt% lss 10 set dt=%dt: =0% 7 8 set file_name=%date:~0,4%%date:~5,2%%date:~8,2%_%dt%_%time:~3,2% 9 set bin_path="c:\MySQL\MySQL Server 5.5\bin\" 10 set save_path="c:\mysql_backup\data" 11 set zip_path="C:\Program Files (x86)\7-Zip\7z.exe" 12 set bak_path="d:\mysql_backup\data" 13 14 echo export_starting 15 %bin_path%mysqldump.exe -uroot -p123 db1> %save_path%\db1_%file_name%.sql 16 %bin_path%mysqldump.exe -uroot -p123 db2> %save_path%\db2_%file_name%.sql 17 echo export_end 18 19 echo zip_starting 20 %zip_path% a -tzip -p123 %save_path%\db1_%file_name%.zip %save_path%\db1_%file_name%.sql 21 %zip_path% a -tzip -p123 %save_path%\db2_%file_name%.zip %save_path%\db2_%file_name%.sql 22 echo zip_end 23 24 echo copy_starting 25 copy %save_path%\db1_%file_name%.zip %bak_path%\db1_%file_name%.zip 26 copy %save_path%\db2_%file_name%.zip %bak_path%\db2_%file_name%.zip 27 echo copy_end 28 29 echo rm_starting 30 del %save_path%\db1_%file_name%.sql 31 del %save_path%\db2_%file_name%.sql 32 echo rm_end 33 34 echo rm_history_starting 35 set DaysAgo=10 36 forfiles /p %save_path% /s /m *.* /d -%DaysAgo% /c "cmd /c del /f /q /a @path" 37 forfiles /p %bak_path% /s /m *.* /d -%DaysAgo% /c "cmd /c del /f /q /a @path" 38 echo rm_history_end 39 40 echo ok
转载于:https://www.cnblogs.com/ezhangliang/archive/2012/06/04/2535145.html