Help Center> GaussDB(for MySQL)> User Guide> Data Backups> Creating a Manual Backup
Updated on 2024-05-21 GMT+08:00
View PDF

Creating a Manual Backup

Scenarios

GaussDB(for MySQL) allows you to create manual backups for the available primary node of your instance. You can restore data from backups to ensure data reliability.

Constraints

  • You can create manual backups only when your account balance is no less than $0 USD.
  • The backup efficiency is in direct proportion to the instance data volume.
  • The system verifies the connection to the DB instance when starting a full backup task. If the backup lock failed to be obtained from the DB instance, the verification fails and a retry is automatically performed. If the retry fails, the backup will fail.
  • When an account is deleted, both automated and manual backups are deleted.

Backup Clearing

When a DB instance is deleted, its automated backups are also deleted, but its manual backups are retained permanently until you manually delete them.

Method 1

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, locate the instance for which you want to create a manual backup and choose More > Create Backup in the Operation column.
  5. In the displayed dialog box, enter a backup name and description. Then, click OK. If you want to cancel the backup creation task, click Cancel.

    • The backup name must consist of 4 to 64 characters and start with a letter. It is case sensitive and can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
    • The description can consist of up to 256 characters. It cannot contain carriage return characters and the following special characters:

      !<"='>&

    • The time required for creating a manual backup depends on the data volume of the instance.
    • When a DB instance is being backed up, data is copied and uploaded to OBS. The time required depends on the amount of data to be backed up.
    Click in the upper right corner of the page to check the instance status. If the instance status is Available, the backup creation is complete.
    Figure 1 Creating a manual backup

  6. View and manage the created backup on the Backups page.

Method 2

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose Backups. On the displayed page, click Create Backup. In the displayed dialog box, enter a backup name and description, and click OK. If you want to cancel the backup creation task, click Cancel.

    • The backup name must consist of 4 to 64 characters and start with a letter. It is case sensitive and can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
    • The description can consist of up to 256 characters. It cannot contain carriage return characters and the special characters (!<"='>&).
    • The time required for creating a manual backup depends on the data volume of the instance.
    • When a DB instance is being backed up, data is copied and uploaded to OBS.
      Figure 2 Creating a manual backup

  6. View and manage the created backup on the Backups page.

APIs

Parent topic: Data Backups