Updated on 2023-03-07 GMT+08:00

Scheduled Backup

Scenarios

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

Procedure

  1. On the top menu bar, choose Background Tasks > Scheduled Backup.
  2. On the task list page, click Set AK/SK in the upper left corner.

    Storage: The system stores encrypted files in OBS buckets.

    AK and SK: Access key ID (AK) and secret access key (SK) are required when cloud services are accessed using development tools (APIs, CLI, and SDKs).

  3. Select an OBS bucket, enter the AK and SK, and click Test AK/SK.
  4. After the test succeeded, click OK.
  5. On the task list page, click Create DB Backup Task.
  6. Enter a task name, select a task type, and select the database and storage information.
  7. Confirm the settings and click OK.
  8. On the task list page, click Details to view the task details.
  9. On the task list page, click Create SQL Result Set Backup Task.
  10. Enter a task name, select a task type, and set the time, backup file format, database, and storage information.
  11. Confirm the settings and click OK.
  12. On the task list page, click Execution Records to view the backup status.
  13. Click Details to view the backup logs.
  14. Click Download to download the backup file.
  15. On the task list page, click Terminate or Pause to stop or pause a task.