Note: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. In the console, you can manually create logical backup files of an entire instance or specified databases/tables and download them. This document describes how to manually restore data from logical backup files.
wget
command for download over the private network at a higher speed. For more information, see Customizing Linux CVM Configurations
Below is a sample:Note:
- You can also click Download to download it directly. However, this may take a longer time.
wget
command 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.
Note:xbstream can be downloaded at Percona official website. Select Percona XtraBackup 2.4.6 or later. For more information on installation, see Installing Percona XtraBackup on Red Hat Enterprise Linux and CentOS.
xbstream -x < test0.xb
Note:Replace
test0.xb
with 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
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.
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 .
Note:Find the backup file with
.sql.qp
extension by decompression time and replacecdb-jp0zua5k_backup_20191202182218
with 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
Note:
- This document takes importing into a local MySQL instance with port 3306 as an example. You can replace it as needed.
- Replace
cdb-jp0zua5k_backup_20191202182218.sql
with the .sql file extracted by qpress.
Was this page helpful?