MySQL Windows Server Backup Script

backup.bat

echo Starting Backup.

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set dt=%%c-%%a-%%b)

For /f "tokens=1-4 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b%%c%%d)

set database=database
set username=root
set password=password
set file=%database%-%dt%-%tm%.sql

echo Backing up to file: %file%

mysqldump --routines -u %username% -p%password% %database% > E:\Backups\%file%

echo Backup Complete!