This topic describes the methods that you can use to back up and restore an ApsaraDB RDS for MySQL instance.
Scenario | Method | References |
---|---|---|
Perform backups | Perform scheduled backups. | Enable the automatic backup feature for an ApsaraDB RDS for MySQL instance |
Perform incremental backups or log backups. | ||
Back up individual databases and tables. | Back up the individual databases and tables of an ApsaraDB RDS for MySQL instance | |
Perform cross-region backups. | Enable cross-region backups for an ApsaraDB RDS for MySQL instance | |
Perform cross-account backups. | Back up and restore data across Alibaba Cloud accounts | |
Perform high-frequency physical backups. | High frequency physical backup | |
Perform high-frequency snapshot backups. | Use the high-frequency snapshot backup feature | |
Store backup files | Store backup files to your Object Storage Service (OSS) bucket. | Back up an ApsaraDB RDS for MySQL, PolarDB for MySQL, or self-managed MySQL instance by using logical backup |
Store backup files to a multi-level storage pool. | What is a storage pool? | |
Download backup files | Manually download backup files. | Download the backup files of an ApsaraDB RDS for MySQL instance |
Configure a policy based on which ApsaraDB RDS can automatically download backup files. | ||
Encrypt backup files | Encrypt backup files at rest. | Encrypt the backup files of an ApsaraDB RDS for MySQL instance |
Encrypt backup files in transit by using SSL. | ||
Restore data | Restore data in a few seconds. | Create a sandbox instance for emergency disaster recovery of an ApsaraDB RDS for MySQL database |
Query data from backup files at high speeds. | Query data from DBS-generated logical backup files | |
Restore individual databases and tables. | Restore individual databases and tables of an ApsaraDB RDS for MySQL instance | |
Restore data to a specific point in time. | Restore the data of an ApsaraDB RDS for MySQL instance | |
Restore data to a new RDS instance. | ||
Restore data to the original RDS instance. | ||
Restore data to an existing RDS instance rather than the original RDS instance. | ||
Restore data to an on-premises database. |