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 instances that use 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 on features

• The advanced download feature allows you to export most schemas. Some schemas cannot be exported.

  • 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 Backup and Restoration page, click Base Backups.

   • Download log backup files

     On the Log Backup tab, find the log backup file that you want to download and click Download in the Actions column of the file. Obtain the internal URL or public URL to download the file.

   • Download data backup files

     1. On the Data Backup tab, 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.

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

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

        Note

        By default, Instance Download is selected.

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

        Important

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

        • If the Download Destination parameter is set to URL, internal and public URLs are generated after the download task is complete. You can select a URL to download the backup data based on your business requirements.

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

        Set the Download Destination parameter to OSS (recommended)

        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 Bucket Name 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 the technical support from the Data Disaster Recovery team.

           • 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 the technical support from the Data Disaster Recovery team.

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

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

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

           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, you are charged a file conversion fee and a traffic consumption fee. For more information, see Billing.

RDS instances that use Premium Local SSDs

Prerequisites

• The RDS instance uses Premium Local SSDs.

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

   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.

5. 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 do not run commands to download backup files, you can directly copy the public URL and enter the public URL in the browser to download the backup files.

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

nohup wget -c -t 0 "URL that is used to download the backup file" -O Path and name of the downloaded backup file > Name of file to which monitoring logs are saved &

The following table describes the parameter in the preceding command.

Example:

nohup wget -c -t 0 "https://dbs-****.aliyundoc.com/****.tar.gz****" -O /backup/examplebackup.tar.gz > /tmp/download.log &

curl

nohup curl -C - --retry 10 "URL that is used to download the backup file" -o Path and name of the downloaded backup file> File to which the monitoring logs are saved &

The following table describes the parameter in the preceding command.

Example:

nohup curl -C - --retry 10 "https://dbs-****.aliyundoc.com/****.tar.gz****" -o examplebackup.tar.gz > /tmp/download.log &