tencent cloud

Feedback

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

    7x24 Phone Support