Script MySQL Bck bat

script_mysql_bkp.bat

FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H)
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H)
set mysqldump="C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe"
set homedir="C:\MySQLWinBackup\"
set fname=%v_date%_%v_time%.sql
echo %vdate% %v_time% - %fname%

cd %homedir%

%mysqldump% --add-drop-table --skip-lock-tables -h localhost --user=root --password=qwe123 oc > %homedir%oc_%fname%