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 /P BACKUP_FILE_=Enter Restore File :

set _SCRIPT_DRIVE=%~d0
SET SCHEMA_PWD=%SCHEMA_USR%
SET ZIPAPP=%_SCRIPT_DRIVE%\ICOOP_ALL\ICORE\ICOOP\DB\7-ZipPortable\App\7-Zip64
SET RESTORE_SQL=%_SCRIPT_DRIVE%\\ICOOP_ALL\\ICORE\\ICOOP\\DB\\0.Restore.Mysql.sql
SET RESTORE_PASS=%_SCRIPT_DRIVE%\ICOOP_ALL\ICORE\ICOOP\DB\0.Restore.pass.cnf
SET BACKUP_FILE=%_SCRIPT_DRIVE%\\ICOOP_ALL\\ICORE\\ICOOP\\DB\\%BACKUP_FILE_%

mysql.exe --defaults-file="%RESTORE_PASS%"  --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=%SCHEMA_USR%  < "%RESTORE_SQL%"
mysql.exe --defaults-file="%RESTORE_PASS%"  --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=%SCHEMA_USR%  < "%BACKUP_FILE%"

:End

SET /P E=Enter to exit 

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