ZCS Administrator Guide 8.0

Network Edition

Back Up the MySQL Database

You can configure ZCS backups to run mysqldump to backup your MySQL database during backup sessions. When this is enabled, a mysqldump backup runs with each full, incremental, and auto-grouped backup.

The mysqldump is a backup of your MySQL database at a specific time. Data changes that occur later than the dump file are written to the binary log.To recover to a specific point in time, binary logging must be enabled. See the Zimbra wiki article, MySQL Backup and Restore.

The MySQL dump files are gzipped and placed in the backup target directory, or to /opt/zimbra/backup, if no directory is specified.

These files can be quite large. Make sure that the free disk space is at least three times greater than the actual mySQL database file for each mySQL database backup file that is saved.

Enable mysqldump to run automatically with your backups, type

zmlocalconfig edit mysql_backup_retention=<N>.

N is the number of copies of the mySQL database backups that are retained.

Note:

To restore a MySQL database, contact Zimbra support for assistance.