This topic describes how to manually back up an ApsaraDB RDS for MySQL instance.
If this is the first time you use the backup feature of ApsaraDB RDS, you must attach the AliyunServiceRoleForDBS policy by using your Alibaba Cloud account. For more information, see How do I create a service-linked role for DBS?
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 Billable items and pricing for the backup storage of an ApsaraDB RDS for SQL Server instance.
If 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.
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 of an ApsaraDB RDS for MySQL instance or Update the minor engine version of an ApsaraDB RDS for MySQL instance.
For more information, see What do I do if my ApsaraDB RDS instance is in the Locking state?
- 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.
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.
Selectfrom the Select Backup Mode drop-down list. Then, set the Backup Policy parameter to Instance Backup.
Selectfrom 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.
Optional. View the progress of the backup task.
The system generates 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 the backup files of an ApsaraDB RDS for MySQL instance.
Creates a backup file for an instance.