for /F "tokens=2-4 delims=/ " %%i in ('date /t') do  set currentdate=%%k-%%i-%%j
for /F "tokens=1-3 delims=: " %%i in ('time /t') do set currenttime=%%i-%%j-%%k

IF "%7"=="y" GOTO :STEP1

:STEP0
SET /P STEP=Please confirm to recover database : [y/n] 

IF "%STEP%"=="y" GOTO :STEP1

:STEP1
SET /P SCHEMA_USR=Enter user :

set _SCRIPT_DRIVE=%~d0
SET ZIPAPP=%_SCRIPT_DRIVE%\ICOOP_ALL\ICORE\ICOOP\DB\7-ZipPortable\App\7-Zip64
SET RESTORE_PASS=%_SCRIPT_DRIVE%\ICOOP_ALL\ICORE\ICOOP\DB\0.Restore.pass.cnf
SET BACKUP_FILE=%_SCRIPT_DRIVE%\\ICOOP_ALL\\ICORE\\ICOOP\\DB\\%SCHEMA_USR%.mysql.%currentdate%_%currenttime%.sql

mysqldump.exe --defaults-file="%RESTORE_PASS%" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --routines --events "%SCHEMA_USR%"  > "%BACKUP_FILE%"

%ZIPAPP%\7z a %BACKUP_FILE%.zip %BACKUP_FILE%

:End

SET /P E=Enter to exit