5.1.2 Backing up the MySQL Database Repository

This section contains information about the Oracle VM Manager MySQL backup facility.

As of Oracle VM Manager Release 3.2.1, backups of the local MySQL database are performed automatically every 24 hours. Backups are stored within /u01/app/oracle/mysql/dbbackup by default, and are rotated regularly so that only the 21 most recent backups are stored at any point in time. Backups make use of the MySQL Enterprise Backup utility. See http://www.mysql.com/products/enterprise/backup.html for more information on the MySQL Enterprise Backup utility.

The MySQL Enterprise Backup package is installed as a dependency during the installation of Oracle VM Manager. On Oracle Linux systems this is handled by installing meb-3.8.0-el6.x86_64.rpm.

On x86 systems, backup configuration options are defined in /etc/sysconfig/ovmm on the Oracle VM Manager host.

To configure the default path used to store MySQL database backup files, locate the following line:

DBBACKUP=/u01/app/oracle/mysql/dbbackup
Note

This path can be changed to an alternate location if you need to cater to disk space requirements.

The default path for the mysqlbackup binary is specified in the following line:

DBBACKUP_CMD=/opt/mysql/meb-3.8/bin/mysqlbackup

Warning

This path is made explicit for the purposes of handling future updates to the MySQL Enterprise Backup package. It should not be changed.