This topic describes how to download unencrypted data and log backup files from an ApsaraDB RDS for MySQL instance. This allows you to manage the files by using an organized method. In addition, you can use the files to restore the data of the RDS instance to an on-premises database.
A RAM user with only read-only permissions cannot download data or log backup files. You can grant the required permissions to the RAM user in the RAM console. For more information, see Grant backup file download permissions to a RAM user with only read-only permissions.
|Database engine||Download of data backup files||Download of log backup files|
||You can download log backup files. You do not need to be concerned about the configuration
of your RDS instance.
Note For more information about how to view log backup files, see How do I use the mysqlbinlog command to view the binary logs of an RDS for MySQL instance?
- Log on to the ApsaraDB for RDS console.
- In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
- Find your RDS instance and click its ID.
- In the left-side navigation pane, click Backup and Restoration.
- Click the Data Backup or Log Backup tab.
- If you want to download a data backup file, click the Data Backup tab.
- If you want to download a log backup file, click the Log Backup tab.
- Specify a time range.
- Find the target data or log backup file and in the Actions column click Download. Note
- If the Download button does not exist, see the "Limits" section in this topic.
- If you want to download a data backup file that is used to restore data, we recommend that you select the file that was created at the closest point in time.
- If you want to download a log backup file that is used to restore data to an on-premises
database, make sure that the file meets the following requirements:
- The Instance ID on the Log Backup tab is the same as the Instance No. on the Data Backup tab.
- The start time of the file is later than the start time of the specified time range. It must also be earlier than the point in time to which you want to restore data.
- In the Download Instance Backup Set message that appears, click Download.
Download method Description Download Use a browser to download the backup file. Copy Internal Endpoint Copy the internal endpoint that is used to download the backup file. If your ECS and RDS instances reside in the same region, you can log on to the ECS instance. Then, you can use the internal endpoint to download the backup file. This is the preferred method that is faster and more secure. Copy Public Endpoint Copy the public endpoint that is used to download the backup file. If you want to use other tools to download the backup file, copy the public endpoint.Note If you are using a Linux operating system, you can run the following command to download the backup file:
wget -c '<The endpoint from which you can download the backup file>' -O <The name of the backup file>
- The -c option enables resumable download.
- The -O option saves the downloaded backup file by using a specified name. We recommend that you use the file name contained in the endpoint.
- If the endpoint contains more than one parameter, enclose the endpoint in a pair of single quotation marks (').
- Why do I find two log backup files with the same name on the Log Backup tab?
The RDS High-availability Edition consists of a primary RDS instance and a secondary RDS instance. Both instances generate log backup files. Each log backup file is identified by an Instance ID on the Log Backup tab. You can distinguish the log backup files generated by the primary RDS instance from those generated by the secondary RDS instance based on their instance IDs. On the Service Availability page, you can view the ID of the primary RDS instance in the Primary Instance No. field. You can also view the ID of the secondary RDS instance in the Secondary Instance No. field.
- What can I do with the data and log backup files that I downloaded?
You can use the data and log backup files that you downloaded to restore data at any time. For more information, see Use a physical backup file to restore an ApsaraDB RDS for MySQL instance to a user-created MySQL database and Restore the data of an ApsaraDB RDS for MySQL instance from a logical backup file to a self-managed MySQL instance.
- Why does the Download button not exist on the Backup and Restoration page?
If your RDS instance runs MySQL 5.7 or 8.0 on RDS Basic or High-availability Edition with standard or enhanced SSDs, you cannot download backup files. However, you can restore data to a new RDS instance. You can also use DTS to migrate data to an on-premises database.
|Query backup sets||Queries the data backup files of an ApsaraDB RDS instance.|
|Query log backup files||Queries the binary log files of an ApsaraDB RDS instance.|