Updated on 2023-12-13 GMT+08:00

Scheduled Backup

Scheduled backup allows you to periodically back up important database tables and data or SQL result sets so that data can be restored timely in case of data loss.

Configuring the AK/SK

Configure AK and SK before you periodically back up database tables or SQL result sets.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Background Tasks > Scheduled Backup.
  7. On the Task List tab, click Set AK/SK in the upper left corner.

    Figure 1 Configuring the AK/SK

  8. In the displayed dialog box, specify Storage, enter an AK and SK, and click Test AK/SK. After the test succeeds, click OK.

    Figure 2 Configuring AK/SK information
    Table 1 Parameter description

    Parameter

    Description

    Storage

    The system stores encrypted files in OBS buckets.

    AK and SK

    AK and SK: Access key ID (AK) and secret access key (SK) are required credentials for you to access Huawei cloud services using development tools like APIs, CLI, and SDKs. The system uses AKs to identify users and SKs to verify encrypted signatures, ensuring that requests are secret, complete, and correct.

Creating a DB Backup Task

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Background Tasks > Scheduled Backup.
  7. On the task list page, click Create DB Backup Task.

    Figure 3 Creating DB backup task button

  8. Enter a task name, select a task type, backup file format, database, and storage path, and enter remarks.

    Figure 4 Creating a DB backup task

  9. Confirm the settings and click OK.
  10. View that the status of the current backup task is Scheduling in the task list.

    You can also view task details and execution records and terminate or pause the task.
    Figure 5 Viewing backup tasks
    • You can click Details to view backup logs.
    • You can click View Execution Records to view the backup status.
    • You can click Terminate to end the backup task.
    • You can click Pause suspend the backup task.

    You can also click Download to download backup data.

    Figure 6 Downloading backup data

Creating a SQL Result Set Backup Task

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Background Tasks > Scheduled Backup.
  7. On the task list tab, click Create SQL Result Set Backup Task.
  8. Enter a task name, select a task type, backup file format, database, and storage path, and enter SQL statements to be executed and remarks.

    Figure 7 Creating a SQL result set backup task

  9. Confirm the settings and click OK.
  10. View that the status of the current backup task is Scheduling in the task list.

    You can also view details and execution records and terminate or suspend a scheduling task.
    Figure 8 Viewing backup tasks
    • You can click Details to view backup logs.
    • You can click View Execution Records to view the backup status.
    • You can click Terminate to end the backup task.
    • You can click Pause suspend the backup task.

    You can also click Download to download backup data.

    Figure 9 Downloading backup data