基本要求:
1,周日全备
2,周一至周六增量备份
3,备份使用backup用户
grant SELECT,RELOAD,SHOW DATABASES,LOCK TABLES,SUPER,REPLICATION CLIENT on *.* to backup@'localhost' identified by '123456';
4,结合计划任务,备份时间为每天02:00:00
#!/bin/bash
bak_dir='/bakup'
day=$(date +%u)
bak_cmd='innobackupex --user=backup --password=123456 --no-timestamp'full_bak()
{[ -d ${bac_dir}/full ] || mkdir -p ${bak_dir}/full${bak_cmd} ${bak_dir}/full/full_$(date +%F) &> /tmp/bakCheck
}incr_bak()
{[ -d ${bak_dir}/incr ] || mkdir -p ${bak_dir}/incr${bak_cmd} --incremental ${bak_dir}/incr/incr_$(date +%F) --incremental-basedir=$1 &> /tmp/bakCheck
}check_bak()
{if grep 'completed OK!' /tmp/bakCheck &> /dev/nullthenecho "bak success..."elseecho "bak failed..."fi
}if [ 7 -eq $day ]
thenfull_bakcheck_bak
elif [ $day -eq 1 ]
thenincr_bak ${bak_dir}/full/full_$(date +%F -d '-1 day')check_bak
elseincr_bak ${bak_dir}/incr/incr_$(date +%F -d '-1 day')check_bak
fi
# Check backup file ,remove history bacupset.
[ -f /tmp/bakCheck ] && rm -f /tmp/bakCheck
find /bakup -type d -name "*`date -d '-7 day' +%F`" -exec rm -rf {} \;