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?
otrs backup
Moderator: crythias
Re: otrs backup
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.
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.
Re: otrs backup
has anyone step the otrs server with any replicaiton software like double-take
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: otrs backup
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.
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.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: otrs backup
what about the mysql db? does the otrs script back that up as well?
marc
marc
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: otrs backup
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
Although, if you use something besides postgres or mysql, it'll error out:"$DBDump -u $DatabaseUser $DatabasePw -h $DatabaseHost $Database > $Directory/DatabaseBackup.sql"
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);
}
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask