Help Center > > User Guide> MySQL DB Instance Management (Development Tool)> Background Tasks> Scheduled Backup

Scheduled Backup

Updated at: Jun 09, 2021 GMT+08:00

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.

    Figure 1 Scheduled Backup

  2. On the task list page, click Set AK/SK in the upper left corner.

    Figure 2 Set AK/SK

    Storage: The system stores encrypted files in OBS buckets.

    AK and SK: Access key ID (AK) and secret access key (SK) are required when HUAWEI CLOUD 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.

    Figure 3 Create DB Backup Task

  6. Enter a task name, select a task type, and select the database and storage information.

    Figure 4 Create DB Backup Task

  7. Confirm the settings and click OK.
  8. On the task list page, click Details to view the task details.

    Figure 5 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.

    Figure 6 Create SQL Result Set Backup Task

  11. Confirm the settings and click OK.
  12. On the task list page, click Execution Records to view the backup status.

    Figure 7 Backup details

  13. Click Details to view the backup logs.

    Figure 8 Backup Details

  14. Click Download to download the backup file.
  15. On the task list page, click Terminate or Pause to stop or pause a task.

    Figure 9 Terminate
    Figure 10 Pause

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel