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

Downloading a Binlog Backup File

Updated at:Nov 20, 2020 GMT+08:00

Scenarios

This section describes how to download a manual or an automated backup file 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 is submitted.

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 Service List. Under Database, click 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 whose size is greater 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 Service List. Under Database, click 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.

    Figure 1 Selecting a download method
    • 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

      OBS outbound public traffic is free of charge for using OBS Browser to download backup data.

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

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

      4. Add an external bucket.

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

        For details about how to add external buckets, see section Adding External Buckets in the Object Storage Service User Guide.

      5. Download a merged binlog.

        On the OBS Browser page, click the bucket that has been successfully added. In the search box on the right of OBS Browser, enter the backup file name displayed on step 3 of Figure 2. 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 wget 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 add -O in the wget command to rename the backup file name.

        DOWNLOAD_URL: indicates the path 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