Backup mysql database using Bat Script,Mysql auto backup script

1. mysqldump.exe is needed
2. Change user name, password,port
3. Change Database Name.
4. Default location C drive.(if you Need to alter)
5. Autobackup script used to call from scheduler tool.

Example:

Echo off 
 set a=C:\
(cd "%a%" && C: && mysqldump  --skip-add-drop-table --routines=true -u root -p1234 --host=192.168.1.235 --port=3306 admin > C:\admin_1732017_151012.sql)> transferlog150312.txt  2>&1
Echo *** Backup Completed ***
Timeout 5

Result:

Download:

Backup Support Files