xtrabackup安装备份mysql

最新推荐文章于 2024-08-07 10:57:30 发布

小白不养兔

最新推荐文章于 2024-08-07 10:57:30 发布

阅读量151

点赞数

本文链接：https://blog.csdn.net/qq_30920479/article/details/107632685

版权

第一步下载安装xtrabackup

[root@node src]# 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本地安装，解决依赖关系；
[root@node src]# yum localinstall percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm
[root@node src]# xtrabackup -version

#!/bin/bash
user=root
passwd=root
DATE=`date +"%Y/%F-%T"`
fullback=/home/backup/full/$DATE
[ ! -d $fullback ] && mkdir $fullback -p
xtrabackup --user=$user --password=$passwd --backup --target-dir=$fullback &> /tmp/mysql
egrep ".* Backup created in directory.*" /tmp/mysql >> /home/backup/full/complete.info
#scp -rp $fullback 192.168.1.188:/fullback
find $fullback/ -ctime +3 -type d -exec rm {} \;