12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-11-26 22:16:29
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
#!/bin/bashecho "start backup"path='/backup/mysql/'paw='123456'if [ ! -d "$path" ]; thenmkdir -p "$path"fi#备份并将备份日志记录下来xtrabackup --
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
#!/bin/bash
echo "start backup"
path='/backup/mysql/'
paw='123456'
if [ ! -d "$path" ]; then
mkdir -p "$path"
fi
#备份并将备份日志记录下来
xtrabackup --backup --user=root --host 172.30.249.57 --password $paw --datadir=/data/DB/mysql --target-dir=$path/backup-$(date +%Y%m%d) > /backup/mysql/`date +'%Y%m%d'`_backup.log 2>&1
#删除7天前的备份
find /backup/mysql -ctime +7 -exec rm -rf {} \;
echo "complete backup"
再使用crontab定时执行
0 4 * * * /root/mysql_backup.sh #每天早上4点执行
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19