Difference between revisions of "Open-Xchange backup"

(Single context restore)
(Backup)
Line 1: Line 1:
 
= Backup  =
 
= Backup  =
  
This article describes what is needed to back up Open-Xchange
+
This article describes what components are needed to back up Open-Xchange and it's data.
  
 
== Configuration ==
 
== Configuration ==
Line 7: Line 7:
 
the complete configuration is in the directory
 
the complete configuration is in the directory
 
  /opt/open-xchange/
 
  /opt/open-xchange/
A backup of the configuration files is recommended once after installation and every change.
+
A backup of the configuration files is recommended once after installation and every change (also before and after any software update).
  
 
==User Data==
 
==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.
 
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
+
It is important that filestore and database are backed up 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  
+
because the meta data for the files in the filestore directories are in the database.  
snapshots or a similar mechanism before backing up the files.
+
The best way to achieve this, is using snapshots or a similar mechanisms.
  
 
===Filestore===
 
===Filestore===
Line 22: Line 22:
  
 
===Database===
 
===Database===
For the Database, the standard mysql tools can be used for backup.
+
For the Database, the standard mysql tools can be used for a backup.
if mysqldump is used to backup the database, following parameters are recommended:
+
If mysqldump is used to backup the database, following parameters are recommended:
 
  mysqldump -–all-databases -–single-transaction
 
  mysqldump -–all-databases -–single-transaction
  

Revision as of 16:07, 15 January 2010

Backup

This article describes what components are needed to back up Open-Xchange and it's data.

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 (also before and after any software update).

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 filestore and database are backed up at the same time. This is because the meta data for the files in the filestore directories are in the database. The best way to achieve this, is using snapshots or a similar mechanisms.

Filestore

For the Filestore, standard tools can be used to perform the backup. Following command gives an overview of all filestore directories.

/opt/open-xchange/sbin/listfilestore

Database

For the Database, the standard mysql tools can be used for a 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 consistency tool has to run for a basic check:

 /opt/open-xchange/sbin/checkconsistency

Single context restore

it is possible to only restore one single context from withing a complete mysql database dump. This is described in the Installation and Administration Manual:

http://software.open-xchange.com/OX6/doc/OX6-Installation-and-Administration.pdf