ApsaraDB RDS:Download backup files

Traffic fee

• Downloads over an internal network: You are not charged for the traffic that you consume.

• Downloads over the Internet: After the free quota of 500 GB per instance-month is exhausted, you are charged for the excess traffic that you consume based on the pay-as-you-go billing method. Fees are deducted from your account on a daily basis. For more information, see Network traffic fees.

Backup set conversion fee

If you use the advanced download feature, the snapshot backup files are converted into CSV files with or without headers, SQL, or Parquet files, and you are charged for conversions. No free quota is provided for backup set conversion. The following table describes the unit prices for backup set conversion in different regions.

RDS instance that uses cloud disks

You can create an advanced download task by point in time or backup set. You can set the Download Destination parameter to URL or directly upload the downloaded data to your OSS bucket to facilitate data analysis and offline archiving.

Limits

• The advanced download feature allows you to export most information about schemas.

  • You can export column information, primary key indexes, non-primary key indexes, unique indexes, partition table information, table engines, and table-level or database-level character sets and character collations.

  • You cannot export expression indexes, foreign keys, generated columns, hidden columns, views, functions, stored procedures, system variables, or triggers.

• The advanced download feature does not support fields of spatial data types. If your RDS instance contains fields of the following spatial data types, backup file conversions fail:

  GEOMETRY, POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, and GEOMETRYCOLLECTION

• The CSV files that you export from your RDS instance do not contain the following system databases:

  information_schema, mysql, performance_schema, sys, and __recycle_bin__

• If you set the Download Destination parameter to OSS, only the Standard storage class is supported. For more information about how to change the storage class, see Convert storage classes.

Procedure

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID.

2. In the left-side navigation pane, click Backup and Restoration.

3. On the page that appears, click the Base Backups tab and then the Data Backup tab.

4. Find the backup set that you want to download and click Download Instance Backup File in the Actions column.

   Note

   • By default, the ApsaraDB RDS console displays the backup sets that are generated over the most recent eight days. If you want to view the backup sets that are generated eight days ago, you must change the default time range.

   • If Download Instance Backup File is not displayed, check whether the major engine version or region of the RDS instance meets the requirements that are described in Prerequisites.

5. In the Point in Time and Backup Set step of the wizard, select Download by Point in Time or Download by Backup Set and then click Next.

   Note

   The Download by Point in Time option is available only when the log backup feature is enabled for your RDS instance. For more information about how to enable the log backup feature, see Use the log backup feature.

6. In the Instance, Database, and Table step of the wizard, click Next.

   Note

   By default, Instance Download is selected.

7. In the Destination and Format step of the wizard, configure the Download Destination parameter and complete the relevant configurations.

   Important

   • We recommend that you set the Download Destination parameter to OSS to ensure efficiency.

   • The backup download task cannot be canceled after it is started.

   Set the Download Destination parameter to OSS (recommend)

   Note

   If you set the Download Destination parameter to OSS, data is directly downloaded to your OSS bucket. You can use and delete the data based on your business requirements.

   1. Configure the Select Bucket and Directory Prefix parameters.

   2. Configure the Download Format parameter.

      Note

      • You can download the backup files in one of the following formats: CSV without headers, CSV with headers, SQL, and Parquet.

      • If you do not have the permissions to access OSS resources, follow the instructions in the console and click Authorize and then Confirm Authorization Policy. After the permissions are granted, configure the parameters for the advanced download task.

   3. Read and select the required content and click Complete.

   4. Go to the Backup Download tab.

      Wait until the Status parameter of the task changes from Running to Finished. You can view and use the downloaded file in the specified OSS bucket.

      Important

      • Computing resources are competed to convert the downloaded backup sets. As a result, temporary resource allocation may fail, and the download task fails. The download task may also fail due to unsupported special data formats. If your download task fails, try again or contact DBS technical support.

      • No fees are generated for failed tasks.

   Set the Download Destination parameter to URL

   Note

   If you set the Download Destination parameter to URL, the downloaded data is temporarily stored in the built-in storage of DBS. No storage fees are generated. For more information, see Built-in storage and OSS.

   1. Configure the Download Format parameter, read and select the required content, and then click Complete.

      Note

      You can download the backup files in one of the following formats: CSV without headers, CSV with headers, SQL, and Parquet.

   2. Wait until the Status parameter of the task changes from Running to Finished.

      Important

      • Computing resources are competed to convert the downloaded backup sets. As a result, temporary resource allocation may fail, and the download task fails. The download task may also fail due to unsupported special data formats. If your download task fails, try again or contact DBS technical support.

      • No fees are generated for failed tasks.

   3. Click Generate Link in the Download Destination column.

   4. In the Generate Link dialog box, configure the Validity Period parameter and click Generate Link. Then, you can download backup data by using the generated URL. For more information, see Appendix: Download commands.

      Important

      • You can obtain the download URL within three days after the download task is complete. The validity period of a download URL can be set to 5 minutes to 1 day. The default validity period is 2 hours.

        After a download task is complete, the download task and the download URL of the task expire three days later. After the expiration, the data of the download task is automatically cleared within a specific period of time. If you do not retain the data within the specified period of time but want to use the data, you must initiate a new download task and obtain a new download URL.

      • We recommend that you save the URL at the earliest opportunity and keep the URL confidential.

      • If you use a third-party download tool to download the backup set, additional download traffic may be generated. As a result, you may be charged additional fees. Proceed with caution.

      • When you perform an advanced download, backup file conversion fees and traffic fees are generated. For more information, see Billing.

RDS instances that uses local disks

Prerequisites

• The RDS instance uses local disks.

  Note

  You can go to the Basic Information page of the RDS instance to view the preceding information.

• The RAM user that you want to use to log on to your RDS instance is granted the permissions to download backup files. For more information about how to grant permissions to a RAM user, see Grant backup file download permissions to a RAM user with read-only permissions.

Procedure

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID.

2. In the left-side navigation pane, click Backup and Restoration. On the page that appears, click the Base Backups tab.

3. Click the Data Backup tab or the Log Backup tab.

4. Select a time range. This step is required if you want to view the backup files that are generated eight days ago. The default time range spans the most recent eight days.

5. Find the backup set that you want to download. In the Actions column, click Download Instance Backup File on the Data Backup tab or Download on the Log Backup tab.

6. In the dialog box that appears, click I have learned the billing rules for backup file and I want to download backup files over the Internet or copy the URL from which you can download the backup file.

   • Copy Internal URL: If you want to connect your virtual private cloud (VPC)-type ECS instance to the RDS instance over an internal network, you can log on to your Elastic Compute Service (ECS) instance and use the internal URL to download the backup file. This method is faster and more secure.

   • Copy Public URL: If the RDS instance cannot be connected over an internal network, you can use the public URL to download the log backup file.

   Note

   • Select I have learnt the billing rules for backup file download. If you use the public URL to download the backup file, you are charged for the excess Internet traffic that you consume. For more information, see Billing.

   • The URLs that can be used to download backup files are valid for only 1 hour. We recommend that you download the URLs at the earliest opportunity. If the download URLs expire, you can refresh the page to obtain the latest download URLs.

   • The download tasks that are run before the URLs expire are not affected after the URLs expire.

   • For more information about how to use the internal or public URL to download backup files, see Appendix: Download commands.

   • If you use the internal URL to download the backup files, make sure that the server to which you log on and the RDS instance reside in the same VPC. If the server and the RDS instance reside in VPCs of different regions or if the server resides in the classic network and the RDS instance resides in a VPC, you cannot download the backup files by using the internal URL on the server.

   • The log backup files that are described in this section are the log backup files that are stored on the RDS instance. For more information about how to obtain the log files, see How do I use the mysqlbinlog command to view the binary logs of an ApsaraDB RDS for MySQL instance?.

   • If the RDS instance runs RDS High-availability Edition or RDS Enterprise Edition, both the primary RDS instance and the secondary RDS instances generate log backup files. You can view the IDs of the primary RDS instance and the secondary RDS instances on the Service Availability page.

   • If you want to restore the data of the RDS instance to a self-managed MySQL instance, the point in time at which the used data backup file is generated must be within the restorable time range that is supported by the log backup file. In addition, the log backup file and the data backup file must have the same instance ID.

wget

Command: nohup wget -c -t 0 "The URL of the backup file to download" -O The destination path and file name > The file to which the downloaded data is saved &
Example: nohup wget -c -t 0 "https://example.aliyundoc.com/examplebackup.qp.xb" -O /backup/examplebackup.qp.xb > /tmp/download.log &
The following list provides the meanings of the options in the preceding command:
-t 0: enables an unlimited number of retries. 
-c: enables resumable uploads. 
-O: specifies the save path and name of the backup file that you want to download. 
nohup: prevents the download from being interrupted when you accidentally replicate data or disconnect your database client during the download. If you specify this option, the download process automatically exits after the download is completed.

curl

Command: nohup curl -C - --retry 10 "The URL that is used to download the backup file" -o The user-defined name of the downloaded backup file> The file to which the downloaded data is saved&
Example: nohup curl -C - --retry 10 "https://example.aliyundoc.com/examplebackup.qp.xb" -o backup.qp.xb > /tmp/download.log &
The following list provides the meanings of the options in the preceding command:
--retry 10: enables up to 10 retries if the download fails. 
-C -: enables resumable uploads. 
-o: specifies the save path and name of the backup file that you want to download. 
nohup: prevents the download from being interrupted when you accidentally replicate data or disconnect your database client during the download. If you specify this option, the download process automatically exits after the download is completed.