@echo off
rem Backup Database (Daily,via Task Scheduler)
set filename="D:\DBBackup\FileName_%date:~7,2%_%date:~4,2%_%date:~10,4%.sql"
C:\wamp\bin\mysql\mysql5.7.14\bin\mysqldump.exe --user=root --password=password --host=localhost --port=3306 --result-file=%filename% --default-character-set=utf8 --single-transaction=TRUE --databases "Database Name"
echo Backup Done