mysql8.0 centos7 xtrabackup步骤

复制代码
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}*
复制代码

 

posted @   大川哥  阅读(109)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单,K8s 太复杂?w7panel 让容器管理更轻松!
点击右上角即可分享
微信分享提示