Full database backup

From Zarafa wiki

Jump to: navigation, search

To create a full backup of the Zarafa MySQL database, the easiest way is to make full back is via the default mysqldump command.
When using this command, it's important that you do not lock the tables.

You can create a full consistent backup with the following command:

mysqldump --single-transaction -p zarafa > zarafa.dump

Note: Never use --opt or --lock with mysqldump!

When the attachments are stored outside the database, a full mysqldump is not enough. To backup the attachments on the filesystem you can use the opensource rsync tool or create a tar of all attachments.

Personal tools