ApsaraDB RDS:Download a log backup

Limitations

• Data backup files cannot be downloaded. To restore data from a data backup, use the restoration feature to restore to the same or a new RDS instance. On the Base Backups tab, click the Data Backup tab and select the backup set from which you want to restore the data of the RDS instance.

• Log backup files can be downloaded.

• A Resource Access Management (RAM) user with only read permissions on the RDS instance cannot download backup files. Grant the required permissions to the RAM user through the RAM console before proceeding.

Prerequisites

Before you begin, ensure that you have:

• Sufficient RAM user permissions to download backup files (not read-only)

• (Optional) A virtual private cloud (VPC)-type Elastic Compute Service (ECS) instance that communicates with the RDS instance over the internal network, for faster and more secure downloads

Download a log backup file

1. Go to the Instances page. In the top navigation bar, select the region where the RDS instance resides. Find the RDS instance and click its ID.

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Base Backups tab, click the Log Backup tab.

4. In the Actions column of the log backup file you want to download, click Download.

   Note

   To restore data to an on-premises database using this log backup file, verify the following before downloading:

   • The instance ID of the log backup file matches the instance ID of the backup set you plan to use.

   • The start time of the log backup file is later than the end time of the backup set and earlier than the point in time you want to restore to.

5. In the dialog box, click Download or copy the URL.

   • Internal URL: If your VPC-type ECS instance communicates with the RDS instance over the internal network, log on to the ECS instance and use the internal URL to download the file. This method is faster and more secure.

   • Public URL: Use this URL if the RDS instance is not accessible over the internal network.

   Note

   On Linux, run the following command to download the file with resumable download support:

   wget -c '<Download URL of the log backup file>' -O <File name>

   • -c: Enables resumable download.

   • -O: Saves the file with the specified name. Use the file name from the download URL.

   • If the URL contains multiple parameters, enclose it in single quotation marks (') to prevent the download from failing.