:: Properties File for Batch

@echo off

cls

c:

cd

cd program filesMySQLMySQL Workbench 6.3 CE

mysqldump -uroot -pRoot_Password -hHost_Server_Name DB_Nbr1 > c:MySQLBackupDB_Nbr1_BU_%date:~10,4%%date:~4,2%%date:~7,2%.SQL


mysqldump -uroot -pRoot_Password -hHost_Server_Name DB_Nbr2 > c:MySQLBackupDB_Nbr2_BU_%date:~10,4%%date:~4,2%%date:~7,2%.SQL


mysqldump -uroot -pRoot_Password -hHost_Server_Name DB_Nbr3 > c:MySQLBackupDB_Nbr3_BU_%date:~10,4%%date:~4,2%%date:~7,2%.SQL


mysqldump -uroot -pRoot_Password -hHost_Server_Name test > c:MySQLBackuptest_BU_%date:~10,4%%date:~4,2%%date:~7,2%.SQL

FOR /F "TOKENS=1-4 DELIMS=," %%F IN (C:MyFileList.properties) DO CALL "C:PathBatchScript.cmd" %%F %%G %%H %%I

@ECHO OFF

CLS

SET User=%1
SET Pass=%2
SET Host=%3
SET DBName=%4

CD /D "C:program filesMySQLMySQL Workbench 6.3 CE"

mysqldump -u%User% -p%Pass% -h%Host% %DBName% > C:MySQLBackup%DBName%_BU_%date:~10,4%%date:~4,2%%date:~7,2%.SQL

GOTO EOF