9.6 Backup Failure for the MySQL Database Repository

If you specify a new MySQL database backup directory, you may encounter a failure during the MySQL database backup if the new directory does not exist, or does not have the correct permissions assigned. By default, the MySQL database backup files are stored within /u01/app/oracle/mysql/dbbackup on the Oracle VM Manager host, but it is possible to set a different directory if required.

Workaround: When changing the default MySQL database backup directory, you must ensure that the new directory exists and has the correct permissions assigned on the Oracle VM Manager host as follows:

  1. Create the new directory that you want to use for the MySQL database backup files, for example:

    # mkdir /u01/app/oracle/mysql/new-backup-dir

  2. Ensure the right permissions are set for the new directory:

    # chmod 777 /u01/app/oracle/mysql/new-backup-dir

  3. Update /etc/sysconfig/ovmm and specify the new directory for the DBBACKUP parameter:

    DBBACKUP=/u01/app/oracle/mysql/new-backup-dir

  4. Save and close /etc/sysconfig/ovmm for the new directory to take effect.

For more information on backing up the MySQL Database repository, see Backing up and Restoring Oracle VM Components in the Oracle VM Administrator's Guide.

Bug 27582009