mysql8.0 centos7 xtrabackup步骤

发布时间 2023-07-26 18:27:03作者: 大川哥
mysql8.0 centos7  xtrabackup步骤
wget https://downloads.percona.com/downloads/Percona-XtraBackup-8.0/Percona-XtraBackup-8.0.33-28/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.33-28.1.el7.x86_64.rpm

yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL perl-Digest-MD5
yum -y install libev


grant BACKUP_ADMIN on *.* to 'root'@'%';
flush privileges;

xtrabackup --user=root --host=10.5.250.58 --password='***' --backup --export --history --compress  --parallel=4 --compress-threads=4 --target-dir=/home/bak/tmp/full

xtrabackup --user=root --password=0Pk(8FiiJYNBA --backup --target-dir=/home/bak

#!/bin/bash

TODAY=`date +%Y%m%d`
last_week=`date --date="$d3-7 day" +%Y-%m-%d`

cd /home/bak

nohup xtrabackup --user=root --password="***" --backup --target-dir=/home/bak/$TODAY  2>&1 & 

mv nohup.out ${TODAY}.out

rm -rf  /home/bak/${last_week}*