Open-Xchange backup: Difference between revisions

From Open-Xchange
Line 13: Line 13:


It is important that the filestore and the database is backed up together at the same time. This is
It is important that the filestore and the database is backed up together at the same time. This is
because the meta data for the files is stored in the database. The best way to achieve this is using  
because the meta data for the files from the filestore is located in the database. The best way to achieve this, is using  
snapshots or similar mechanism. In case the database and the filestore are not in sync following
snapshots or a similar mechanism before saving the files.
tool is needed to resolve inconsistencies:
/opt/open-xchange/sbin/checkconsistency


===Filestore===
===Filestore===

Revision as of 15:44, 15 January 2010

Backup

This article describes what is needed to back up Open-Xchange

Configuration

the complete configuration is in the directory

/opt/open-xchange/

A backup of the configuration files is recommended once after installation and every change.

User Data

All user Data is in the Mysql Database as well as in the location of the registered filestores as nomal files in the filesystem.

It is important that the filestore and the database is backed up together at the same time. This is because the meta data for the files from the filestore is located in the database. The best way to achieve this, is using snapshots or a similar mechanism before saving the files.

Filestore

For the Filestore, standard tools can be used for backup Following command gives an overview of directories that have to be backed up:

/opt/open-xchange/sbin/listfilestore

Database

For the Database, the standard mysql tools can be used for backup. if mysqldump is used to backup the database, following parameters are recommended:

mysqldump -–all-databases -–single-transaction

Restore

In case of a restore, it is recommended to restore database and filestore data that have been backed up at the same time to avoid inconsitencies. After a restore the consistencie tool has to run for a check:

 /opt/open-xchange/sbin/checkconsistency