Predmet:Re: MySql upute za start
Napravi BAT fajl za beckup
evo scripta
PreuzmiIzvorni kôd (Visual Basic):@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