mysql 备份脚本（xtrabackup）

remington_young

#!/bin/sh　　
set -x
　　
USER=root
　　
PASSWORD=123456
　　
time=`date +"%y-%m-%d-%H-%M"`
　　
date >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　

　　
#1 begin Full Backups
　　
echo "begin backup--------------------------------" >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
   /usr/bin/innobackupex --defaults-file=/etc/my.cnf  --user=$USER --password=$PASSWORD --use-memory=2GB  --parallel=4  --no-timestamp /data/mysqlbackup/full-$time 2>>/data/mysqlbackup/logs/$time'_allbackup.log'
　　
cp /etc/my.cnf /data/mysqlbackup/full-$time/my.cnf.bk
　　
echo "end backup----------------------------------" >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　

　　
#2 begin compress
　　
echo "Begin compress------------------------------" >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
    archivename=full-$time
　　
echo "The archive time is  $time" >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
    tarname=$archivename.tar.gz
　　
echo "The tar name is $tarname" >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
cd /data/mysqlbackup
　　
/bin/tar -zcvf ./$tarname ./$archivename >> /data/mysqlbackup/logs/$time'_allbackup.log' 2>&1
　　
rm -rf /data/mysqlbackup/full/xtrabackup_checkpoints
　　
cp /data/mysqlbackup/full-$time/xtrabackup_checkpoints /data/mysqlbackup/full/xtrabackup_checkpoints
　　

　　
#3 Delete Document
　　
file=/data/mysqlbackup/$tarname
　　
if [[ -e $file ]]
　　
    then
　　
        echo "The $tarname file exists.begin to perform delete action"   >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
        /bin/rm -rf /data/mysqlbackup/$archivename
　　
    else
　　
        echo "The file is not exists." >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　
    fi
　　

　　
date >> /data/mysqlbackup/logs/$time'_allbackup.log'
　　

　　
find /data/mysqlbackup/*tar.gz -ctime +1|xargs -I '{}'  mv  {}  /data/ftp
　　

　　
cd /data/ftp
　　

　　
function logftp (){
　　
ftp -v -n xxx.xxx.xxx.xxx >/data/mysqlbackup/logs/to_ftp.log
　　

　　
cd /data/ftp
　　

　　
find /data/ftp/*tar.gz |xargs rm -rf