Help Center> Relational Database Service> User Guide> Working with RDS for MySQL> Data Backups> Downloading a Full Backup File
Updated on 2024-04-03 GMT+08:00
View PDF

Downloading a Full Backup File

Scenarios

This section describes how to download a manual or an automated backup for local storage.

RDS for MySQL allows you to download full backup files in .qp format.

Constraints

  • Full backup files of frozen DB instances cannot be downloaded.
  • When you use OBS Browser+ to download backup data, there is no charge for the outbound traffic from OBS.
  • If the size of the backup data is greater than 400 MB, you are advised to use OBS Browser+ to download the backup data.

Method 1: Using OBS Browser+

  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 Databases > Relational Database Service.
  4. On the Backups page, locate the backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the Full Backups page, locate the backup to be downloaded and click Download in the Operation column.

  5. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account. For details about how to enable operation protection, see Identity and Access Management User Guide.

  6. In the displayed dialog box, select Use OBS Browser+ for Download Method and click OK.

    Figure 1 Using OBS Browser+
    Figure 2 Download guide
    1. Download OBS Browser+ following step 1 provided on the download guide page.
    2. Decompress and install OBS Browser+.
    3. Log in to OBS Browser+ using the username provided in step 2 on the download guide page.
      Figure 3 Logging in to OBS Browser+
    4. Add an external bucket using the bucket name provided in step 2 on the download guide page.
      Figure 4 Adding an external bucket

      If you want to access OBS external buckets across accounts, the access permission is required. For details, see Granting IAM Users Under an Account the Access to a Bucket and Resources in the Bucket.

    5. Download the backup file.

      On the OBS Browser+ page, click the bucket that you added. In the search box on the right of the object list page, enter the backup file name provided in step 3 on the download guide page. In the search result, locate the target backup and click in the Operation column.

      Figure 5 Downloading a backup

Method 2: Using Current Browser

  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 Databases > Relational Database Service.
  4. On the Backups page, locate the backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the Full Backups page, locate the target backup to be downloaded and click Download in the Operation column.

  5. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account. For details about how to enable operation protection, see Identity and Access Management User Guide.

  6. In the displayed dialog box, select Use Current Browser for Download Method and click OK.

    Figure 6 Using the current browser

Method 3: Using Download URL

  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 Databases > Relational Database Service.
  4. On the Backups page, locate the backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the Full Backups page, locate the target backup to be downloaded and click Download in the Operation column.

  5. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account. For details about how to enable operation protection, see Identity and Access Management User Guide.

  6. In the displayed dialog box, select Use Download URL for Download Method, click to copy the URL, and enter the URL in your browser.

    Figure 7 Using the download URL

    A valid URL for downloading the backup data is displayed.

    • You can use various download tools, such as your browser to download backup files.
    • You can also run the following command to download backup files:

      wget -O FILE_NAME --no-check-certificate "DOWNLOAD_URL"

      The parameters in the command are as follows:

      FILE_NAME: indicates the new backup file name after the download is successful. 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 backup file to be downloaded. If the location contains special characters, escape is required.

Parent topic: Data Backups