Creating a Manual Backup

Scenarios

RDS allows you to create manual backups of a running primary DB instance. You can use these backups to restore data.

(CBR Disabled)

• You can create manual backups only when your account balance is no less than $0 USD.
• When you delete a DB instance, its automated backups are also deleted but its manual backups are retained.
• The number of tables in a DB instance affects the backup speed. The maximum number of tables is 500,000.
• The system verifies the connection to the DB instance when starting a full backup task. If either of the following conditions is met, the verification fails and a retry is automatically performed. If the retry fails, the backup will fail.
  • DDL operations are being performed on the DB instance.
  • The backup lock failed to be obtained from the DB instance.

Constraints (CBR Enabled)

• The backup time is proportional to how much data your instance has. Too much data can decrease the backup efficiency. If you have large amounts of data and want to speed up the backup process, contact customer service to enable Cloud Backup and Recovery (CBR).
• After CBR is enabled, snapshot backup is used. Existing automated and manual backups can still be used to restore data.
• When you delete a DB instance, its automated backups are also deleted but its manual backups are retained.
• DDL operations cannot be performed when a CBR snapshot is being created. If a DDL operation is being performed, a snapshot will be created after the DDL operation is complete.
• After CBR is enabled, the next full backup is a snapshot backup. You can use the snapshot backup to restore data.

Billing

Backups are saved as packages in OBS buckets. For the billing details, see How Is RDS Backup Data Billed?

After a DB instance is deleted, the free backup space of the DB instance is automatically canceled. Manual backups are billed based on the space required. For details, see Product Pricing Details.

After CBR is enabled, the free backup space is unavailable. You are billed for database server backup vaults on a pay-per-use basis. For details, see How Is CBR Billed?

Method 1

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, locate the target DB instance and choose More > Create Backup in the Operation column.
5. In the displayed dialog box, enter a backup name and description. Then, click OK.
   • The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
   • The description consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=
   • The time required for creating a manual backup depends on the amount of data.

   To check whether the backup has been created, you can click in the upper right corner of the page to check the DB instance status. If the DB instance status becomes Available from Backing up, the backup has been created.

6. After a manual backup has been created, you can view and manage it on the Backups page.

   Alternatively, click the target DB instance. On the Backups & Restorations page, you can view and manage the manual backups.

Method 2

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the target DB instance.
5. On the Backups & Restorations page, click Create Backup. In the displayed dialog box, enter a backup name and description and click OK.
   • The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
   • The description consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=
   • The time required for creating a manual backup depends on the amount of data.

6. After a manual backup has been created, you can view and manage it on the Backups page.

   Alternatively, click the target DB instance. On the Backups & Restorations page, you can view and manage the manual backups.