Downloading a Binlog Backup File
Scenarios
RDS for MySQL allows you to download binlog backup files for local storage. For details, see Downloading a Binlog Backup File or Downloading a Merged Binlog.
Downloading a Binlog Backup File
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service.
- On the Instances page, click the target DB instance. The Basic Information page is displayed.
- In the navigation pane on the left, choose Backups & Restorations. On the Binlog Backups page, locate the target backup to be downloaded and click Download in the Operation column.
- After the download is complete, you can view the binlog backups on your computer.
Downloading a Merged Binlog
If the total size of binlogs within the selected period is greater than 500 MB, the binlogs cannot be merged.
When binlogs of a single-node instance are being merged, the CPU usage of the instance increases. Consider the impact on the instance performance before merging binlogs.
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service.
- On the Instances page, click the target DB instance. The Basic Information page is displayed.
- In the navigation pane on the left, choose Backups & Restorations. On the Merged Binlogs page, select a binlog time range and click Merge.Note
- The maximum time range can be merged is 24 hours.
- The available time range is consistent with the retention period you have set for the automated backups. For details about how to set the retention period, see Configuring an Intra-Region Backup Policy.
- During the merging process, the merged file status is Creating. Wait until the status becomes Completed and click Download in the Operation column.
- In the displayed dialog box, select a method to download the merged binlog.Note
- To reduce backup storage usage, delete the merged binlog after the download is complete. On the Merged Binlogs page, you can locate the target merged binlog to be deleted and click Delete in the Operation column.
- If you do not manually delete the merged binlogs, they will be deleted 30 days later.
- Use Download URL
Click
to copy the URL within the validity period to download the merged binlog.
- You can use other download tools to download the merged binlog.
- You can also run the following command to download the merged binlog:
wget -O FILE_NAME --no-check-certificate "DOWNLOAD_URL"
Variables in the commands are as follows:
FILE_NAME: indicates the new name of the merged binlog file. The original backup file name may be too long and exceed the maximum characters allowed by the client file system. You are advised to use the -O argument with wget to rename the backup file.
DOWNLOAD_URL: indicates the location of the merged binlog to be downloaded. If the location contains special characters, escape is required.
- Scenarios
- Downloading a Binlog Backup File
- Downloading a Merged Binlog