#!/bin/bash

 mysql_backup_dir=/data/databaseup/

 mysql_username="root"

 mysql_password="password"

 databasename="database1 database2"

 lastweek=$(date "+%y%m%d" -d "last week")

 timeStart=$(date '+%Y%m%d%H%M%S')

 dataname=${mysql_backup_dir}${timeStart}

 logfile=${mysql_backup_dir}/full-${timeStart}.log

 echo "开始备份..."`date`

 innobackupex --user=$mysql_username --password=$mysql_password --defaults-file=/etc/my.cnf --database="$databasename" --no-lock --stream=xbstream --tmpdir=$mysql_backup_dir --sleep= --throttle= --compress --compress-threads= $mysql_backup_dir > ${dataname}.xbstream > "$logfile"

 mkdir -p ${dataname}

 xbstream -x < ${dataname}.xbstream -C ${dataname}

 innobackupex --decompress ${dataname} > "$logfile"

 find ${dataname} -name "*.qp" | xargs rm -f

 innobackupex --defaults-file=/etc/my.cnf --user=root --password=cff1981@wit --use-memory=4G --apply-log ${dataname} > "$logfile"

 echo "备份完毕..."`date`

 echo "删除老的备份..."`date`

 cd ${mysql_backup_dir} && ls|grep ${lastweek} |xargs rm -rf

 echo "删除老的备份完毕..."`date`