Backing up OTRS

[tco]

We are running OTRS 2.4 on mySql on top of Fedora Core 12 in a Windows network.

What is the best strategy for backups?

Thanks

[stanhale]

I think the best way is to use "backup.pl" from $OTRS_HOME/scripts

[tco]

We saw the scripts in the documentation.

However, we we looking at a other solutions to back up the entire box. We are running Fedora 12 on a vmWare virtual box with vmWare Essentials.

Thanks

[mario156]

if u using vmware u can easly backup the hole virtual-disk / do regulary snapshots or what ever

[snazza]

In our enviroment, we use a three server architecture (open source):

1) OTRS server
2) Mysql DB mirror (using replication functions of mysql)
3) BackupPC server doing regular snapshots of the mirror.

[210nitesh]

I think the best way is to use "backup.pl" from $OTRS_HOME/scripts

Pls tell me in detail how to run backup.pl

if possible pls mail me screenshot of all steps. it urgent i need it badly

[meronbar]

Backup entire virtual box spend a lot of disk size, as there is only full copy.
I guess it is better to backup only database often (daily) as they only changed in working process, and entire system sometime.
Also this is related to your general backup process, as just dump database to same disk it is not a backup

[Daniel Obee]

...I guess it is better to backup only database often (daily) as they only changed in working process, ...

Don't forget to backup the file system too! By default it's in the /var/ directory. Else you'd loose th entire attachments and stay with just the text mails.

Greets
Daniel

[michelle]

Hey,

I am new to OTRS, just testing it for now.
I have installed it on my regular windows 7 - not an official server and it works great.

Now I want to try and backup the files but am not sure how to go about this.
Enetered mySQL bin folder through the cmd but I don't know which files in OTRS I am supposed to back up.
Can someone tell me which files are the data base files and how do I back up them?

Thank you so much
Michelle

[crythias]

It's pretty much the same thing, cross platform. Run the backup.pl script with the appropriate options.

[n0manarmy]

I use a cron job to backup and copy off the files every night to a network share that I have mapped on my Linux box. It's easier to manage backups with Windows so I just dump the backups to one of our regular file servers where the sys admins hit the directory with their tapes and store it away

The script that I use with the cron job is listed below

The first line searches the directory for anything over 10 days old and removes them.
The second line launches the script
The third line moves it to a mounted network share

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
find /mnt/dentalfs05/otrs/* -mtime +10 -exec rm {} \;
perl /opt/otrs/scripts/backup.pl -d /opt/otrs/backup
mv /opt/otrs/backup/* /mnt/dentalfs05/otrs/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~