1. 全库备份
vim all_db_bak.sh
PATH="/usr/local/mysql/bin:$PATH"
BAK1=/bak1
BAK2=/bak2
TIME=$(date +"%F:%H:%M:%S")
USER=root
PASS=123456
if [ ! -d $BAK1 -o ! -d $BAK2 ];then
mkdir $BAK1
mkdir $BAK2
mysqldump -u$USER -p$PASS --all-databases > /$BAK1/all_${TIME}.sql
cp $BAK1/all_${TIME}.sql $BAK2
echo -e "\033[32mMySQL数据已全库备份到 ${BAK2} 目录\033[0m"
else
mysqldump -u$USER -p$PASS --all-databases > /$BAK1/all_${TIME}.sql
cp $BAK1/all_${TIME}.sql $BAK2
echo -e "\033[32mMySQL数据已全库备份到 ${BAK2} 目录\033[0m"
fi
2. 增量备份
[mysqld]
log-bin = "/home/mysql/logbin.log"
binlog-format = ROW
log-bin-index = "/home/mysql/logindex"
binlog_cache_size=32m
max_binlog_cache_size=512m
max_binlog_size=512m
重启 mysql,其中路径 /home/mysql 的用户和组要改成 mysql
mkdir -p /home/mysql/backup/daily
vim binlogbak.sh
PATH="/usr/local/mysql/bin:$PATH"
export LANG=en_US.UTF-8
BakDir=/home/mysql/backup/daily
BinDir=/home/mysql
LogFile=/home/mysql/backup/binlog.log
BinFile=/home/mysql/logindex.index
mysqladmin -uroot -p123456 flush-logs
Counter=`wc -l $BinFile |awk '{print $1}'`
NextNum=0
for file in `cat $BinFile`
do
base=`basename $file`
NextNum=`expr $NextNum + 1`
if [ $NextNum -eq $Counter ]
then
echo $base skip! >> $LogFile
else
dest=$BakDir/$base
if(test -e $dest)
then
echo $base exist! >> $LogFile
else
cp $BinDir/$base $BakDir
echo $base copying >> $LogFile
fi
fi
done
echo `date +"%Y年%m月%d日 %H:%M:%S"` Bakup succ! >> $LogFile
3. 开启定时任务
vim /etc/crontab
0 3 * * 0 /home/mysql/all_db_bak.sh >/dev/null 2>&1
0 3 * * 1-6 /home/mysql/binlogbak.sh >/dev/null 2>&1
crontab /etc/crontab
crontab -l
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)