<will-bloggs-too>

I got a little paranoid with MySQL running in Windows 2003, so I wrote a quick script to make backup script of the databases along with the save date:

@echo off
FOR /F “TOKENS=1* DELIMS= ” %%A IN (’DATE/T’) DO SET CDATE=%%B
FOR /F “TOKENS=1,2 eol=/ DELIMS=/ ” %%A IN (’DATE/T’) DO SET mm=%%B
FOR /F “TOKENS=1,2 DELIMS=/ eol=/” %%A IN (’echo %CDATE%’) DO SET dd=%%B
FOR /F “TOKENS=2,3 DELIMS=/ ” %%A IN (’echo %CDATE%’) DO SET yyyy=%%B
SET date=%mm%%dd%%yyyy%

echo Running MySQL5 Backups
“C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump” -uroot -p[PASS] -P [PORT] –result-file=”c:\backup\[HOSTNAME].%date%.sql” –all-databases –verbose –add-drop-table -add-locks -f
echo Done!