自动备份mysql和项目的bat脚本

set mysqlPassword=123456
set mysqlDatabaseName=bos
set srcDir=C:\workspace_x64\misshop\WebRoot\WEB-INF\project
set destDir=D:\bak
echo ———————————begin———————————————-
set today=%date:~0,4%%date:~5,2%%date:~8,2%
set todayDestDir=%destDir%\%today%
echo create backup folder ‘%todayDestDir%’ for today:
mkdir %todayDestDir%
mkdir %todayDestDir%\project
mkdir %todayDestDir%\sql
echo waiting…
xcopy /E %srcDir% %todayDestDir%\project
echo ——————————-begin mysql—————————————-
echo backup mysql…
mysqldump -uroot -p%mysqlPassword% %mysqlDatabaseName% > %todayDestDir%\sql\%mysqlDatabaseName%%today%.sql
echo ———————————end—————————————————