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.

When you delete an instance, its automated backups are also deleted but its manual backups are retained.

When an account is deleted, both automated and manual backups are deleted.

Constraints

• 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.

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 Database > 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.

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 Database > 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 1 Creating a manual backup
     

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