WINDOWS 服务器MYSQL自动备份打包脚本

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"

md "d:\mysql_backups\%ymd%"

"C:\MySQL\bin\mysqldump.exe" --opt -Q mysql -uroot -p123456 > d:\mysql_backups\%Ymd%\mysql.sql
REM ..... 你有多少个数据库，其中 -Q 后面是数据库名称 -p紧跟后面是密码

echo Winrar loading...

"C:\Program Files\WinRAR\WinRAR.exe" a -ep1 -r -o+ -m5 -df "D:\mysql_backups\[%Ymd%]VPS-sql.rar" "d:\mysql_backups\%Ymd%"

echo OK!