Mysql dump windows

Quelques paramètre sont spécifiques pour une remontée du dump dans la supervision

@ECHO on

REM Variables MySQL
SET BACKUP_DIR=C:\MySQL_Backup
SET DUMP_OPTS=
SET MYSQL_BIN=C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
SET MYSQLDUMP_BIN=C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe
SET MYSQLDUMP_ERRORS_LOG=%TEMP%\sqldump_errors.log
SET PASSWORD=V01ZaZou
SET PORT=3306
SET RETENTION=8
SET SERVER=localhost
SET SQLDUMP_FILE=%%I_%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%_%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.sql
SET USER=root

REM Variables VisionClient
SET BINPATH=D:\\Work\\Tools\\usr\\local\\wbin
SET COLOR=green
SET HOSTNAME=preprodwsrv1.mfa.fr
SET LIFETIME=1440
SET PATH=%PATH%;%BINPATH%
SET SERVICE=backup
SET SUPERVISION=10.252.15.235
SET TEMP=C:\\work\\Temp
SET VISION_CLIENT=C:\\Agarik

REM Suppression des dumps de plus de 7 jour et déplacement des dumps de la veille dans le dossier OLD
FORFILES /P "%BACKUP_DIR%\OLD" /D -%RETENTION% /M * /C "CMD /C DEL /Q /S @path"
FORFILES /P "%BACKUP_DIR%\CURRENT" /D -1 /M * /C "CMD /C MOVE /Y @path %BACKUP_DIR%\OLD"

REM Dump des BDD
"%MYSQL_BIN%" --user=%USER% --password=%PASSWORD% -BNe "SHOW DATABASES" > %TEMP%\BDD.txt
FOR /F %%I IN (%TEMP%\BDD.txt) DO (
        "%MYSQLDUMP_BIN%" --skip-lock-tables --user=%USER% --password=%PASSWORD% %%I 2>"%MYSQLDUMP_ERRORS_LOG%" | gzip -c > "%BACKUP_DIR%\CURRENT\%SQLDUMP_FILE%.gz"
)

FOR /R %%J IN (%MYSQLDUMP_ERRORS_LOG%) DO (
        IF %%~zi neq 0 GOTO MYSQLGREEN
        ELSE GOTO MYSQLRED
)

:MYSQLRED
SET COLOR=red
GOTO EOS

:MYSQLGREEN
SET COLOR=green
GOTO EOS


:EOS
REM "%VISION_CLIENT%"\VisionSvc.exe /file %SUPERVISION% 1984 status+%LIFETIME% %HOSTNAME%.%SERVICE% %COLOR% %MYSQLDUMP_ERRORS_LOG%