Manually back up an ApsaraDB RDS for MySQL instance - ApsaraDB RDS

This topic describes how to manually back up an ApsaraDB RDS for MySQL instance.

Prerequisites

The AliyunServiceRoleForDBS service-linked role is created by using your Alibaba Cloud account if you use the backup feature of ApsaraDB RDS for the first time. For more information, see How do I create a service-linked role for DBS?

Billing rules

A free quota on backup storage is provided for your RDS instance. If the total size of the backup files of your RDS instance does not exceed the free quota, no backup fees are generated. If the total size exceeds the free quota, you are charged for the excess backup storage that you use. For more information about the free quota and billing rules, see Backup storage fees.

Usage notes

If the minor engine version of your RDS instance meets the following conditions, the RDS instance cannot be backed up after it is locked:

Any minor engine version if the RDS instance runs MySQL 5.1 or MySQL 5.5.
20190815 or earlier if the RDS instance runs MySQL 5.6, MySQL 5.7, or MySQL 8.0.

Note

For more information about how to upgrade the major engine version or update the minor engine version of an RDS instance, see Upgrade the major engine version or Update the minor engine version.
For more information, see What do I do if my ApsaraDB RDS instance is in the Locking state?

Procedure

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the upper-right corner of the page that appears, click Backup Instance.

In the Backup Instance dialog box, select a backup policy to back up specific databases and tables or back up all databases. Then, click OK.

Instance category

Backup of all databases

Backup of specified databases

RDS instances that use local disks

Use one of the following backup methods:

Select Physical Backup from the Select Backup Mode drop-down list. The speeds of physical backup and restoration are faster than the speeds of logical backup and restoration.
Select Logical Backup from the Select Backup Mode drop-down list. Then, set the Backup Policy parameter to Instance Backup.

Select Logical Backup from the Select Backup Mode drop-down list. Then, set the Backup Policy parameter to Single-Database Backup.

RDS instances that use cloud disks

Select Snapshot Backup from the Select Backup Mode drop-down list.

Not supported.

Optional. View the progress of the backup task.
The system creates a backup task. You can click the icon in the upper-right corner of the page. On the Tasks page, set the Task Type parameter to Manual Backup and view the backup progress.
Note
After the backup task is complete, you can download the backup file on the Base Backups tab of the Backup and Restoration page. For more information, see Download backup files.

What to do next

After the backup task is complete, you can download the backup file on the Base Backups tab of the Backup and Restoration page. For more information, see Download backup files.
You can also call the CreateBackup operation to create a backup set.
For more information about data backups and data restoration methods, see Methods of backing up and restoring an ApsaraDB RDS for MySQL instance and Overview of data restoration methods.