Help Center > > User Guide> Working with RDS for MySQL> Backups and Restorations> Downloading a Binlog Backup File

Downloading a Binlog Backup File

Updated at: May 14, 2021 GMT+08:00

Scenarios

This section describes how to download a manual or an automated backup to a local device and restore data from the backup file.

RDS for MySQL enables you to download binlog backup files. For details, see Downloading a Binlog Backup File or Downloading a Merged Binlog.

Only MySQL 5.6 and 5.7 DB instances support the download of merged binlogs.

The completion time displayed in the binlog backup file list indicates the time when the last transaction was submitted.

Binlog backups on the management console are named in the format of "binlog name+timestamp" and use the row-based logging.

Binlog backup files of frozen DB instances cannot be downloaded.

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. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance. The Basic Information page is displayed.
  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 locally.

Downloading a Merged Binlog

Merged binlogs larger than 500 MB cannot be downloaded.

  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. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance. The Basic Information page is displayed.
  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 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 Automated Backup Policy.

  6. During the merging process, the merged 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 method to download the merged binlog.

    • 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 OBS Browser+

      When you use OBS Browser+ to download backup data, there is no charge for the generated outbound traffic.

      Figure 1 Using OBS Browser+ to download a merged binlog
      1. Download OBS Browser+ following the step 1 provided in Figure 1.
      2. Decompress and install OBS Browser+.
      3. Log in to OBS Browser+.

        For details about how to log in to OBS Browser+, see Logging In to OBS Browser+ in the Object Storage Service Tools Guide.

      4. Add an external bucket.

        In the Add Bucket dialog box of OBS Browser+, select Add external bucket and enter the bucket name provided in step 2 of Figure 1.

      5. Download a merged binlog.

        On the OBS Browser+ page, click the bucket that you added. In the search box on the right of OBS Browser+, enter the backup file name displayed on step 3 of Figure 1. In the search result, locate the target merged binlog and download it.

    • Use Current Browser

      Download the merged binlog directly from the current browser.

    • 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 -OFILE_NAME--no-check-certificate"DOWNLOAD_URL"

        Variables in the commands are described as follows:

        FILE_NAME: indicates the new merged file name after the download. 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel