mysql_backup.bat

@echo off

set /p=Press ENTER to start the backup...

set dbName=DBNAME
set dbUser=DBUSER
set dbPassword=BDPASS
set backupDir="C:\backups"
set mysqldump="C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe"

for /F "usebackq tokens=1,2,3 delims=-" %%I IN (`echo %date%`) do echo "%%I" "%%J" "%%K"
set date=%date:/=_%

%mysqldump% --host="localhost" --user=%dbUser% --password=%dbPassword% --single-transaction --add-drop-table --routines --databases %dbName% > %backupDir%\%dbName%_%date%.sql