@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