tencent cloud

All product documents
TDSQL-C for MySQL
Downloading and Decompressing Backup
Last updated: 2023-02-08 09:46:36
Downloading and Decompressing Backup
Last updated: 2023-02-08 09:46:36
The TDSQL-C for MySQL console provides the list of logical backup files that can be downloaded. They may then be used to restore data from one database to another (such as a self-built database or a database provided by another cloud vendor).

File Types Supported for Download, Decompression, and Deletion

Category
Backup Type
Method
Download
Decompression Required After Download
Deletion
Data backup
Logical backup
Full backup
Manual
Binlog backup
Binlog backup
Incremental backup
Automatic
x

Downloading a Data Backup File

1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top, find the target cluster, and click the cluster ID or Manage in the Operation column to enter the cluster management page.
3. On the cluster management page, select Backup Management > Data Backup List to view the backup file.


4. In the Operation column of a data backup file, click Download.
5. In the pop-up window, click Copy to get the file download address for fast download by running the wget command, or directly click Download.
Note:
After copying the download address, log in to a Linux CVM instance as instructed in Customizing Linux CVM Configurations and run the wget command for download.
If the cluster and CVM instance are in the same region, the wget command can be used for fast download over the private network, no matter whether they are in the same or different VPCs.
If the cluster and CVM instance are in different regions, fast download over the private network is not supported, and the public IP must be enabled for the CVM instance before the wget command can be used for download.
The download address is valid for 12 hours, after which you will need to enter the download page again to get a new one.
The URL must be enclosed with quotation marks when the wget command is used to download.
wget command format: wget -c " " -O .xb


Downloading a Binlog Backup File

1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top, find the target cluster, and click the cluster ID or Manage in the Operation column to enter the cluster management page.
3. On the cluster management page, select Backup Management > Binlog Backup List to view the backup file.


4. In the Operation column of a data backup file, click Download.
5. In the pop-up window, click Copy to get the file download address for fast download by running the wget command, or directly click Download.
Note:
After copying the download address, log in to a Linux CVM instance as instructed in Customizing Linux CVM Configurations and run the wget command for download.
If the cluster and CVM instance are in the same region, the wget command can be used for fast download over the private network, no matter whether they are in the same or different VPCs.
If the cluster and CVM instance are in different regions, fast download over the private network is not supported, and the public IP must be enabled for the CVM instance before the wget command can be used for download.
The download address is valid for 12 hours, after which you will need to enter the download page again to get a new one.
The URL must be enclosed with quotation marks when the wget command is used to download.
wget command format: wget -c " " -O .xb


Decompressing a File

To save storage space, TDSQL-C for MySQL data and binlog backup files will be compressed with qpress and then packed with xbstream offered by Percona. Therefore, downloaded backup files can be imported to the target database only after being unpacked and decompressed.

Unpacking a backup file

Unpack the backup file with xbstream.
Note:
xbstream can be downloaded at Percona's official website. Select Percona XtraBackup v2.4.6 or later. For more information on installation, see Installing Percona XtraBackup on Red Hat Enterprise Linux and CentOS.
xbstream -x < test0.xb -P
Note:
Replace test0.xb with your backup file name.
The unpacking result is as shown below:



Decompressing a backup file

1. Download qpress by running the following command.
wget -d --user-agent="Mozilla/5.0 (Windows NT x.y; rv:10.0) Gecko/20100101 Firefox/10.0" https://docs-tencentdb-1256569818.cos.ap-guangzhou.myqcloud.com/qpress-11-linux-x64.tar
Note:
If an error is displayed during the wget download, you can click here to download qpress locally and upload it to the Linux CVM instance. For more information, see Uploading Files from Linux or MacOS to Linux CVM via SCP.
2. Extract the qpress binary files by running the following command:
tar -xf qpress-11-linux-x64.tar -C /usr/local/bin
source /etc/profile
3. Decompress the backup file with qpress.
qpress -d <backup file>.sql.qp .

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon