Windows mysqldump备份+rar压缩

windows mysqldump备份+rar

@echo off

set mysqlbasedir=E:\mysql

set mysqlbackdir=E:\backup

set databasename=xxx

set user=root

set userpass=xxx

set riqi=%date:~0,4%%date:~5,2%%date:~8,2%

set keeptime=7

E:

cd %mysqlbasedir%/bin

mysqldump --max_allowed_packet=512M -u%user% -p%userpass% --master-data=2  --single-transaction -B %databasename% >%mysqlbackdir%\"mysqlback_%riqi%.sql"

c:

cd C:\Program Files (x86)\WinRAR

rar A %mysqlbackdir%\mysqlback_%riqi%.rar %mysqlbackdir%\"mysqlback_%riqi%.sql"

forfiles /P "%mysqlbackdir%" /s /m *.rar /d -%keeptime% /c "cmd /c del @path"

forfiles /P "%mysqlbackdir%" /s /m *.sql /c "cmd /c del @path"

@echo on

exit