基于Innobackupex的MySQL备份脚本

基本要求：

        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/null
   then
        echo "bak success..."
   else
        echo "bak failed..."
   fi
}if [ 7 -eq $day ]
then
     full_bak
     check_bak
elif [ $day -eq 1 ]
then
     incr_bak ${bak_dir}/full/full_$(date +%F -d '-1 day')
     check_bak
else
     incr_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 {} \;