How is backup OTRS 3.x in Windows 2008?

[Reva]

I have windows 2008 + OTRS 3.0.6 (mysql + apache).

How to backup OTRS by the schedule without the use of the commercial programs? As I understand, there are must stop all services and make the backup OTRS folder(C:\Program Files\OTRS) using 7zip (for example). This script can be put in sheduller.
1) When I restore the database from this backup, the database of mysql to be operable?
2) Can someone have already written the script for this and give a link to it?
3) The folder C:\Program Files\OTRS weighs 1,1 Gb and will grow.
Is the right, make the backup this folder by the archiver (7zip)?

Maybe someone has other ideas about the backup on a schedule?

[crythias]

There's a file called backup.pl that can be used to back up OTRS. http://doc.otrs.org/3.0/en/html/backup- ... tml#backup

[Reva]

I install Gzip for Windows. Then I run backup.pl and I get error. See below

c:\Windows\System32>cscript.exe "C:\Program Files\OTRS\OTRS\scripts\backup.pl" -d C:\backup\OTRS -c gzip -t fullbackup
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

Input Error: There is no script engine for file extension ".pl".

[Reva]

I execute backup.pl (with perl.exe) again and I see error:

C:\Program Files\OTRS\StrawberryPerl\perl\bin>perl.exe "C:\Program Files\OTRS\OTRS\scripts\backup.pl" -d C:\backup\OTRS -c gzip -t fullbackup
'which' is not recognized as an internal or external command,
operable program or batch file.
ERROR: Can't locate cp!

Where is the mistake?

[Reva]

Script backup.pl makes backup only a xNIX, using perl. (You can see the contents of the script backup.pl)
I wrote a script for Windows:
- Stopping services OTRS
- backup of the target folder
- starting services OTRS
The size of the backup is about 250 Mb

[qt_zetroc]

Hi Reva,

This sounds interesting. Would you mind sharing us your script?Or maybe can keep between us by sending via PM.

Many Thanks and have a great day!

[MichaelR]

Easiest way is to backup during a period of inactivity
1. mysqldump
2. copy OTRS folder
3. keep a manual backup of the sysconfig

Should be about it, not to hard to write a small batch file

[kettysimpson]

If you want to backup the OTRS will have to follow the simple steps 1) make SQL dump first of all. 2) After that copy the complete OTRS directory. 3) Than for a restore the backup reinstall OTRS package copy back the OTRS directory and than reload the sql backup in mysql database. 4) And for downloading the settings Download all system config changes." and the Load Settings in [SysConfig]