腾讯云rds备份集下载后使用

 

1.物理备份集解密
1.1 解密腾讯云下载的备份集
/opt/xtrabackup247/bin/xbstream -x --decrypt=AES256 --encrypt-key-file=/soft/hxl_tengxunyun/hxl_mysql5.7_cdb648386_backup_20261111144448.xb.key --parallel=8 -C /soft/hxl_tengxunyun/mybak < /soft/hxl_tengxunyun/hxl_mysql5.7_cdb648386_backup_20261111144448.xb

秘钥文件key可以直接在控制台下载

 

1.2 解压decompress
/opt/xtrabackup247/bin/xtrabackup --parallel=8 --decompress --remove-original --target-dir=/soft/hxl_tengxunyun/mybak

 

2.binlog解密
2.1 获取key
[root@flink-113 hxl_tengxunyun]# cat hxl_mysql5.7_cdb648386_binlog_mysqlbin.000005.key
247A8BC924C1391AD5F2A45229FE70E5

 

2.2 解密
openssl enc -d -aes256 -k 247A8BC924C1391AD5F2A45229FE70E5 -in hxl_mysql5.7_cdb648386_binlog_mysqlbin.000005 -out hxl_mysql5.7_cdb648386_binlog_mysqlbin.000005_jiemi

 

3.逻辑备份下载后解压成SQL

 

[root@flink-113 aa]#/opt/xtrabackup247/bin/xbstream -x<hxl_mysql8_cdb648507_backup_20261112093717.xb

[root@flink-113 aa]#qpress -d cdb-6oeldl3f_backup_20261112093717.sql.qp ./