mysql innobackup_mysql innobackup 备份脚本

1 #!/bin/bash2 #Every 14 times the backup fora cycle3

4 format_time=`date +"%Y-%m-%d_%H:%M:%S"`5 week=`date +%w`6 backupbin=/usr/bin/

7 backdir=/export/mysql_backup8 tardir=/export/mysql_backup/beifen9 tarback=`date +"%Y-%m-%d"`10 file_cnf=/etc/my.cnf11 user_name=root12 password=123

13 db="bridge bridgemini xr_wp bridgecharge"

14 out_log=$backdir/xtrabackup_log15 time_cost=$backdir/timecost.txt16 tar_cost=$backdir/tarcost.txt17 bakdate=`date +"%m-%d"`18 num_file=`ls -1 $tardir|wc -l`19 ###########################################20 #yesterday=`date -d "yesterday" +"%m-%d"` #21 #ENDTIME=`date +"%Y-%m-%d %H:%M:%S"` #22 #begin_date=`date -d "$BEGINTIME" +%s` #23 #end_date=`date -d "$ENDTIME" +%s` #24 #spendtime=`expr $end_date -$begin_date` #25 ###########################################26

27 if [ ! -d "$backdir" ];then

28 mkdir -p $backdir29 fi

30

31

32 if [ ! -d "$tardir" ];then

33 mkdir -p $tardir34 fi

35

36 if [ -f "$tardir/rec7.tar.gz" ];then

37 mkdir -p $tardir/$tarback38 mv $tardir/*.tar.gz $tardir/$tarback39 fi40

41

42 if [ -d "$backdir/rec7" ];then43 tar -zcvf $tardir/backup_$bakdate.tar.gz $backdir/* --exclude beifen44 rm -rf $backdir/full $backdir/rec* $backdir/*.txt45 fi46 if [ $num_file -ge 3 ]; then47 rm -r `ls -rt $tardir/*|head -n1`48 fi49

50

51 #Full backup52

53 if [ ! -d "$backdir/full" ];then54 BEGINTIME=`date +"%Y-%m-%d %H:%M:%S"`55 echo "##### Full backup at $BEGINTIME start" >> $time_cost56 innobackupex --defaults-file=$file_cnf --no-timestamp --user=$user_name --password=$password --socket=/tmp/mysql.sock $backdir/full 1> $out_log.full_$format_time.txt 2>&157 ENDTIME=`date +"%Y-%m-%d %H:%M:%S"`58 echo " It takes full backup at $ENDTIME END" >> $time_cost59 begin_date=`date -d "$BEGINTIME" +%s`60 end_date=`date -d "$ENDTIME" +%s`61 spendtime=`expr $end_date - $begin_date`62 echo " Run time full backup $spendtime sec " >> $time_cost63 `cat $time_cost |mail -s 'mysql backup time' wangshj@quanjing.com`64 exit 065 fi66

67 i=168 while [ ${i} -lt 14 ];do69 # The No.$i incremental backup!!70 if [ ! -d "$backdir/rec$i" ];then71 BEGINTIME=`date +"%Y-%m-%d %H:%M:%S"`72 echo "##### The No.$i incremental backup at $BEGINTIME Start!" >> $time_cost73 innobackupex --defaults-file=$file_cnf --no-timestamp --user=$user_name --password=$password --socket=/tmp/mysql.sock --incremental $backdir\/rec$i --incremental-basedir=$backdir/full 1> $out_log.rec$i.$format_time.txt 2>&174 ENDTIME=`date +"%Y-%m-%d %H:%M:%S"`75 echo "It takes rec$i backup at $ENDTIME END!" >> $time_cost76 begin_date=`date -d "$BEGINTIME" +%s`77 end_date=`date -d "$ENDTIME" +%s`78 spendtime=`expr $end_date - $begin_date`79 echo "Run time No.$i $spendtime sec! " >> $time_cost80 `cat $time_cost |mail -s 'mysql backup time' wangshj@quanjing.com`81 exit 082 fi83 i=`expr $i + 1`84 done