Our test box is a standard Windows 7 machine. I've setup two batch files that are scheduled to run nightly. Here is the first batch file used to create a dump of the database and will datestamp the file name. It stores it in a directory labeled Backup, but you could change that to a network folder share or USB drive, etc.
Code: Select all
setlocal
set BackUpFilePath=C:\Backup\
set BackUpFileExt=.sql
set BackUpFileName=otrs%BackUpFileExt%
set MyBackUpFile=%date:~4%
set MyBackUpFile=%MyBackUpFile:~-4%-%MyBackUpFile:~,2%-%MyBackUpFile:~3,2%
set MyBackUpFile=%BackUpFilePath%%MyBackUpFile%_%BackUpFileName%
:startbatch
"c:\Program Files\OTRS\mysql\bin\mysqldump.exe" -u otrs -phot otrs > "%MyBackUpFile%"
Code: Select all
setlocal
set BackUpFilePath=C:\Backup\
set BackUpFileExt=.zip
set BackUpFileName=Archive%BackUpFileExt%
set MyBackUpFile=%date:~4%
set MyBackUpFile=%MyBackUpFile:~-4%-%MyBackUpFile:~,2%-%MyBackUpFile:~3,2%
set MyBackUpFile=%BackUpFilePath%%MyBackUpFile%_%BackUpFileName%
:startbatch
"c:\Program Files\7-Zip\7z.exe" a -r "%MyBackUpFile%" "C:\program files\otrs\otrs\*"