I have automated my mySQL db backup on my Windows 2003 server using AT.exe. I have scheduled a job like this, which is working fine.
AT 23:59 /EVERY:m,t,w,th,f,s,su c:\path\backup.bat
In the backup.bat file, is this line
C:\wamp\bin\mysql\mysql5.5.20\bin\mysqldump -u username -ppassword --result-file="c:\automatedDBBackups\backup.%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%.sql" dbname
I would like to specify a compression format for the output file.