@echo off
rem ****************** BACKUP DATABASE ********************
set dbUser=root
set dbPassword=admin
set backupDir="C:\BCK"
set Baza="2017"
set mysqldump="C:\BCK\mysqldump.exe"
set mysqlDataDir="C:\Program Files(86)\MySQL\MySQL Server 5.0\data"
set zip="C:\BCK\7za.exe"
set hh=%time:~0,2%
set min=%time:~3,2%

 echo. | date | FIND "(mm" > NUL
  If errorlevel 1,(call :Parsedatum DD MM) Else,(call :Parsedatum MM DD)
  goto :EOF
 :Parsedatum
  For /F "tokens=1-4 delims=/.- " %%A in ('date /T') do if %%D!==! (
     set %1=%%A&set %2=%%B&set YYYY=%%C
   ) else (
     set %1=%%B&set %2=%%C&set YYYY=%%D)
 
set znak=_
set rut=C:\BCK\
Set datum=%YYYY%%znak%%MM%%znak%%DD%_%hh%_%min%
set putanja=%rut%%datum%
md %putanja%
%mysqldump% --host=localhost --user=%dbUser% --password=%dbPassword% --single-transaction --add-drop-table --databases %Baza%  > %putanja%\%Baza%.sql

rem ****************** COMPRES DATABASE ********************
set Ime=TEST
C:\BCK\7za.exe a -tgzip %putanja%\%Ime%_%datum%.sql.gz %putanja%\%Baza%.sql

del %putanja%\%Baza%.sql