Creating a Manual Backup

Scenarios

GaussDB(for MySQL) allows you to create manual backups for available DB instances. You can use these backups to restore data.

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.
• The time required for creating a manual backup depends on the data volume of the DB 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.

Backup Clearing

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

Creating a Manual Backup

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 of the page and 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.
   Figure 1 Creating a backup
   

   Alternatively, on the Instances page, click the instance name. Choose Backups in the navigation pane and click Create Backup.

   Figure 2 Creating a backup
   

5. In the displayed dialog box, enter a backup name and description and click OK.
   Figure 3 Creating a backup
   
   • The backup name must start with a letter and consist of 4 to 64 characters. Only letters (case-sensitive), digits, hyphens (-), and underscores (_) are allowed.
   • The backup description consists of up to 256 characters. It cannot contain carriage returns or any of the following special characters: !<"='>&

6. View the created backup on the Backups page.

Deleting a Manual Backup

1. On the Backups page, locate the backup you want to delete and click Delete in the Operation column.

   Alternatively, on the Instances page, click the instance name. On the Backups page, locate the backup you want to delete and click Delete in the Operation column.

   The following backups cannot be deleted:

   • Automated backups
   • Backups that are being restored or created

2. In the displayed dialog box, click OK.

APIs

• Creating a Manual Backup
• Querying Backups