To save storage capacity, 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. In the console, you can manually create logical backup files and download the logical backup files of an entire instance or specified databases or tables. This document describes how to manually restore data from logical backup files.
wgetcommand to download over the private network for higher speed.
- You can also click Download to download it directly, which 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 -x < test0.xb
test0.xbwith your backup file.
The unpacking result is as shown below:
If an error is displayed during the
wgetdownload, you can go to QuickLZ's official website to download qpress locally and upload it to the Linux CVM instance. For more information, please see Uploading Files via SCP to a Linux CVM from Linux.
tar -xf qpress-11-linux-x64.tar -C /usr/local/bin source /etc/profile
qpress -d cdb-jp0zua5k_backup_20191202182218.sql.qp .
The decompressing result is as shown below:
Find the backup file with
.sql.qpextension by decompression time and replace
cdb-jp0zua5k_backup_20191202182218with its filename.
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 extracted by qpress.