5.1.2.2 Performing a Backup Manually

It is possible to initiate a backup manually. This is usually done when performing an upgrade of Oracle VM Manager. While it is possible to invoke the mysqlbackup utility directly, it is recommended that you initiate a backup directly from the Oracle VM Manager core. This can be achieved using the provided backup script at /u01/app/oracle/ovm-manager-3/ovm_tools/bin/BackupDatabase script:

# /u01/app/oracle/ovm-manager-3/ovm_tools/bin/BackupDatabase -w

Enter your OVM Manager username: admin
Enter your OVM Manager password: 

INFO:  Backup started to:
         /u01/app/oracle/mysql/dbbackup/ManualBackup-20140324_102412

       Job: 'Start Backup to: ManualBackup'

By default, the backup script stores the backup as a manual backup, to avoid the rotation that takes place for other automatic backups. The backup script prompts you for your Oracle VM Manager username and password.

In the example above, we used the -w command-line switch to force the backup script to wait until the backup job is complete. This option is useful if you need to capture potential error messages, but you should be aware that using it also causes the script to wait indefinitely, until the job either completes or exits due to an error. If you choose not to use the -w command-line switch, you should check the status of the backup job within the Oracle VM Manager Web Interface or Oracle VM Manager Command Line Interface to determine whether or not the job completed successfully. A full list of supported options for this command can be obtained using the -h command-line switch. These are not fully documented here as most of the options provided are not supported for customer use.

Note

The backup script assumes that you are using a properly signed SSL certificate within a production environment. Using a self-signed certificate is not recommended and may result in an error when you run the script. It is possible to override SSL verification by using the --insecure command-line parameter, however this may compromise the security of the operation and is not recommended. A better approach to resolving any SSL verification error, is to install an SSL certificate signed by a recognized CA, as described in Changing the SSL Key.

For more information on using MySQL Enterprise Backup, see http://dev.mysql.com/doc/mysql-enterprise-backup/en.