otrs backup

[mritorto]

What files or directories or mysql dbs need to be backed up in order to restore an otrs server?

Also can a replication software like double=take or xosoft be used for replicate the data from one otrs server in one site to another site?

[adrijang]

Hi mritorto

I think OTRS_HOME/scripts/backup.pl and OTRS_HOME/scripts/restore.pl is enough, but you can copy OTRS_HOME and export the configuration file too.
Don't forget to SetPermissions.pl on the new server.

[mritorto]

has anyone step the otrs server with any replicaiton software like double-take

[crythias]

It would appear that the software provider for your backup solution could assist you with this.

In general, unless you're constantly making changes to your otrs *directory*, you probably don't need more than a day old copy of it, and likely the configuration of otrs is one-off, generally, so real time high availability of the configuration/themes/directory structure of OTRS is ... well, up to your tolerance level, but likely a standard back up of the directory structure on a nightly basis is probably adequate. Your tolerance for this may vary, but since the folder structure is copyable, a regularly scheduled rsync could also suffice, with little or no problems with open files.

This leaves the database and possibly (if you change from database storage of attachments to file system storage of attachments) file system storage of attachments.

The latter is a simple file/folder copy/rsync and the former is specifically related to how your software backs up/replicates the database.

Master/Slave for MySQL is an option in case someone is interested in working this outside of backup software. A video tutorial on MySQL master/slave is also available.

Edit: The video makes it clear that Master-Slave can lose transactions when the master server is down. Clustering may be more important for high availability. My first statement is probably the most appropriate: check with your software provider for information regarding MySQL high availability.

[mritorto]

what about the mysql db? does the otrs script back that up as well?

marc

[crythias]

The otrs script says "yes" ... but don't take my word for it. check out the otrs/scripts/backup.pl and look for # backup database

"$DBDump -u $DatabaseUser $DatabasePw -h $DatabaseHost $Database > $Directory/DatabaseBackup.sql"

Although, if you use something besides postgres or mysql, it'll error out:

Code: Select all

# check db backup support
if ( $DatabaseDSN =~ /:mysql/i ) {
    $DB     = 'MySQL';
    $DBDump = 'mysqldump';
}
elsif ( $DatabaseDSN =~ /:pg/i ) {
    $DB     = 'PostgreSQL';
    $DBDump = 'pg_dump';
}
else {
    print STDERR "ERROR: Can't backup, no database dump support!\n";
    exit(1);
}