@echo off


REM ************************************************
SET BACAD_DATA_DIR=c:\bacad data
SET HOST=localhost
SET PORT=3306
SET USER=root
SET PASSWORD=
SET DATABASE=bcd_bacad
REM ************************************************


echo BACAD BACKUP
echo ------------
echo.

SET filename=%BACAD_DATA_DIR%\bck\%DATABASE%_%date:~6,4%.%date:~3,2%.%date:~0,2%
IF "%1" == "single" (SET filename=%BACAD_DATA_DIR%\bck\%DATABASE%)

echo Dumping database
"%BACAD_DATA_DIR%\AdminTools\bin\mysqldump.exe" --column-statistics=0 --host %HOST% --port %PORT% --user=%USER% --password=%PASSWORD% --disable-keys --add-drop-table --skip-quote-names --result-file "%filename%.sql" %DATABASE%

echo Compressing backup
"%BACAD_DATA_DIR%\AdminTools\bin\7za.exe" a "%filename%.zip" "%filename%.sql"

echo Deleting temp files
Del "%filename%.sql"
timeout /T 10