To save the storage space, physical and logical backups in TencentDB for MySQL will be compressed with qpress and then packed with xbstream offered by Percona.
TencentDB for MySQL supports logical backup as described in Backing up Databases. You can manually generate and download logical backup for the entire instance or specified databases/tables. This document describes how to manually restore data from logical backup files.
wgetto download the file over the high-speed private network.
Below is a sample:Note：
- You can also click Download to download it directly. However, this may take longer.
wgetcommand format: wget -c 'backup file download address' -O custom filename.xb
wget -c 'https://mysql-database-backup-bj-118.cos.ap-beijing.myqcloud.com/12427%2Fmysql%2F42d-11ea-b887-6c0b82b%2Fdata%2Fautomatic-delete%2F2019-11-28%2Fautomatic%2Fxtrabackup%2Fbk_204_10385%2Fcdb-1pe7bexs_backup_20191128044644.xb?sign=q-sign-algorithm%3Dsha1%26q-ak%3D1%26q-sign-time%3D1574269%3B1575417469%26q-key-time%3D1575374269%3B1517469%26q-header-list%3D%26q-url-param-list%3D%26q-signature%3Dfb8fad13c4ed&response-content-disposition=attachment%3Bfilename%3D%2141731_backup_20191128044644.xb%22&response-content-type=application%2Foctet-stream' -O test0.xb
Unpack the backup file with xbstream.
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
test0.xbwith your backup file.
The unpacking result is as shown below:
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
If an error is displayed during the
wgetdownload, 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.
Extract the qpress binary files by running the following command:
tar -xf qpress-11-linux-x64.tar -C /usr/local/bin source /etc/profile
Decompress the backup file with qpress.
qpress -d cdb-jp0zua5k_backup_20191202182218.sql.qp .
Find the backup file with
.sql.qpextension by decompression time and replace
cdb-jp0zua5k_backup_20191202182218with its filename.
The decompressing result is as shown below:
Import the .sql file into the target database by running the following command:
mysql -uroot -P3306 -h127.0.0.1 -p < cdb-jp0zua5k_backup_20191202182218.sql
- This document takes importing into a local MySQL instance with port 3306 as an example. You can replace it as needed.
cdb-jp0zua5k_backup_20191202182218.sqlwith the .sql file actually extracted by qpress.