rem *******************************Code Start*****************************
@echo off
set "Ymd=%Date:~0,4%%Date:~5,2%%Date:~8,2%%Time:~0,2%%Time:~3,2%%Time:~6,2%"
E:\phpStudy\MySQL\bin\mysqldump --opt -u root --password=123456 db1 > D:\db_backup\db1_%Ymd%.sql
E:\phpStudy\MySQL\bin\mysqldump --opt -u root --password=123456 db2 > D:\db_backup\db2_%Ymd%.sql
C:
cd "C:\Program Files\2345Soft\HaoZip\
HaoZipC a -tzip D:\db_backup\zip\jifeng_%Ymd%.zip D:\db_backup\db1_%Ymd%.sql
HaoZipC a -tzip D:\db_backup\zip\demo_%Ymd%.zip D:\db_backup\db2_%Ymd%.sql
@echo on
rem *******************************Code End*****************************