Restore Mysql database using mysqldump

Restore Mysql database using mysqldump

1. mysqldump.exe and Mysql.exe is needed Or Install mysql on Local system.

Example:

Echo off 
 set a=C:\Program Files\MySQL\MySQL Server 5.6\bin
(cd "%a%" && C: && mysql --host=192.168.1.235 -uroot -p1234 --port=3306 blr < C:\blr.sql)> transferlog190553.txt  2>&1
Echo *** Restored Completed ***
Timeout 5

Result:

Download Bat Script:
https://drive.google.com/file/d/17DzYOvJU_zUMuseFqfZlm_f2w0IlW8-T/view?usp=sharing