mysql定时备份数据库

rem *******************************Code Start***************************** @echo off set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" C:\"Program Files"\MySQL\"MySQL Server 5.7"\bin\mysqldump -uroot -p"shitibang123456" -P3309 --databases shitibang > E:\db_backup\%Ymd%_shitibang.sql C:\"Program Files"\MySQL\"MySQL Server 5.7"\bin\mysqldump -uroot -p"shitibang123456" -P3309 --databases stb > E:\db_backup\%Ymd%_stb.sql @echo on rem *******************************Code End***************************** rem *******************************Code Start****