Oracle Cloud Infrastructure Documentation

Creating a Manual Backup

Use the Console or the command-line interface to create a manual backup of the DB system.

Using the Console

Use the Console to create a manual backup of your DB system.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click DB systems.
  2. Choose your compartment from the List scope.
  3. Do one of the following:
    • Choose Create manual backup from the Actions menu on the same line as your DB system.
    • Click the name of the DB system to open the DB system details page. Under Resources, select Backups, and click Create manual backup.
  4. In the Create manual backup panel, provide the following information:
    • Display name: Specify the name of the backup. If you do not define a name, MySQL HeatWave Service generates one for you in the format, NameOfDBSystem-Backup-Date, Time.
    • Description: Specify a description of the backup. If you do not define a description,MySQL HeatWave Service generates one for you in the format, NameOfDBSystem-Backup-Date, Time.
    • Backup type: Specify the backup type, full or incremental.
    • Retention period: Specify the number of days the backup is retained. You can either select the number of days of retention or the end date of the retention.
  5. Click Create manual backup to create the backup.
MySQL HeatWave Service immediately starts to create the manual backup. The DB system state changes to Updating while creating the manual backup, and returns to the original state once the backup is created. There is no other impact on the DB system.

Using the CLI

Use the command-line interface to create a manual backup.

This task requires the following:
  • A DB system OCID.
  • A policy that permits you to create backups in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
Do the following on the CLI to create a backup:
  1. Open a command prompt, and run the following command:
    oci mysql backup create 
--db-system-id <DBSystemOCID> 
--backup-type FULL 
--display-name <BackUpName>
--retention-in-days <NumberOfDays>

    • db-system-id: Specify the OCID of the DB system.

    • backup-type: (Optional) Specify the type of backup, FULL or INCREMENTAL. The default value is INCREMENTAL.

    • display-name: (Optional) Specify the display name of the DB system. If you do not define a display name, one is generated for you in the mysqlbackupYYYYMMDDHHMMSS format.

    • retention-in-days: (Optional) Specify the number of days the backup is retained. The default retention period is 365 days.

MySQL HeatWave Service immediately starts to create the manual backup. There is no other impact on the DB system.