Creating a Database-Level Backup

Scenarios

You can create database-level backups for DB instances running properly. The database-level backups can be used to restore data, ensuring data reliability.

Constraints

• To use this function, submit a service ticket to request required permissions.
• When you delete a DB instance, its automated backups are also deleted but its database-level backups are retained.
• You can create database-level backups only when your account balance is no less than $0 USD.
• The backup name must be unique.
• Database-level backups are logical backups and do not support PITR. You can only restore data from a single database-level backup to the original DB instance, but not to a new instance.
• Additional storage space will be used during the backup process. To prevent backup failures, ensure that you have enough storage space available.

Billing

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

Procedure

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 DB instance name.
5. In the navigation pane on the left, choose Backups & Restorations.
6. Click the Database Backups tab and click Create Backup.

   Alternatively, click Create Backup on the Full Backups tab page. In the dialog box displayed on the right, select Databases for Backup Type.

7. In the displayed dialog box, enter a backup name and description, set Backup Type to Databases (default), select the database to be backed up, and click OK.
   • The backup name can contain 4 to 64 characters and must start with a letter. Only letters (case-sensitive), digits, hyphens (-), and underscores (_) are allowed.
   • 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 database-level backup depends on how much data there is in the database.
   Figure 1 Creating a database-level backup
   

8. After the creation is complete, click View. In the dialog box displayed on the right, you can download the backup of the specified database and perform a database-level restoration.
   Figure 2 Backup created