1 安装依赖包
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL libev
2下载、安装XBK
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.12/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm
yum -y install percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm
3 xbk全备
innobackupex --user=root --password=123456 --no-timestamp /data/backup/full_`date +%F`
模拟数据目录被删
4 恢复备份前,数据处理准备
[root@db01 ~]# innobackupex --apply-log /data/backup/xbk/full_`date +%F`
5 将备份数据移动到数据目录下,并授权
[root@db01 /data/backup/full_2020-05-12]# cp -a ./* /data/mysql/
[root@db01 /data/backup/full_2020-05-12]# chown -R mysql.mysql /data
6 启动数据库
这里报错是因为配置文件/etc/my.cnf指定了错误日志和二进制日志的目录,但是rm -rf /data/mysql/* 把指定的文件目录删了
所以这里要手动创建出来