Downloading a Binlog Backup File

Scenarios

You can download binlog backups for audit, local storage, or query. For details, see Downloading a Binlog Backup File or Downloading a Merged Binlog.

Constraints

• The completion time displayed in the binlog backup list indicates the time when the last transaction was committed.
• Binlog backups on the management console are named in the format of "binlog name+timestamp" and use the row-based logging.
• Binlog backups of frozen DB instances cannot be downloaded.
• If the total size of binlogs within the selected period is greater than 500 MB, the binlogs cannot be merged for download.
• 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.

Downloading a Binlog Backup File

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Database > Relational Database Service.
4. On the Instances page, click the target DB instance to go to the Basic Information page.
5. 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.

   You can also select the binlog backups to be downloaded and click Download above the list.

6. After the download is complete, you can view the binlog backups on your computer.

Downloading a Merged Binlog

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Database > Relational Database Service.
4. On the Instances page, click the target DB instance to go to the Basic Information page.
5. In the navigation pane on the left, choose Backups & Restorations. On the Merged Binlogs page, select a binlog time range and click Merge.
   • The maximum time range for merging binlogs 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 Same-Region Backup Policies.

6. During the merging process, the file status is Merging. Wait until the status becomes Merged successfully and click Download in the Operation column.
7. In the displayed dialog box, select a download method.
   

   After the merged file is downloaded, delete it. The system will delete it after 30 days if you do not delete it yourself.

   On the Merged Binlogs page, you can locate the target merged binlog to be deleted and click Delete in the Operation column.

   • 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.