Mysql迁移xtrabackup_xtrabackup迁移mysql5.7.32

问题描述：利用外部xtrabackup工具来做迁移mysql数据库，或者恢复数据库

xtrabackup迁移mysql

1.环境

mysql源库

mysql目标迁移库

IP

192.168.163.3

196.168.163.16

操作系统

Ceontos7.8

Ceontos7.8

数据库版本

mysql-5.7.32

mysql-5.7.32

mysql实例

db_hzh03

db_hzh03

my.cnf路径

/data/mysql-5.7.32/db_hzh03/conf/hzh03.cnf

/data/mysql-5.7.32/db_hzh03/conf/hzh03.cnf

socket路径

/data/mysql-5.7.32/db_hzh03/mysql.sock

/data/mysql-5.7.32/db_hzh03/mysql.sock

xtrabackup版本

xtrabackup-24

xtrabackup-24

2.Xtrabackup安装

在源库和目标库都安装percona-xtrabackup-24-2.4.21-1.el7.x86_64.rpm

Xtrabackup下载路径

2.1软件安装

wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.21/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.21-1.el7.x86_64.rpm

链接：https://pan.baidu.com/s/1mPIcKyleAVKTWk_chPFzZw

提取码：htmy

2.2安装依赖包

yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

2.