数据备份脚本

#!/bin/bash

USER=
PASSWORD=""
DATABASE=""
HOSTNAME="127.0.0.1"

BACKUP_DIR=/data/mysqldata/data-bak/
LOGFILE=/data/mysqldata/data-bak/data_backup.log
DATE=`date '+%Y%m%d'`
DATE_DEP=`date -d "-2 week" '+%Y%m%d'`
DUMPFILE=$DATE.sql.gz
OPTIONS="-h$HOSTNAME -u$USER -p$PASSWORD -R $DATABASE"
if [ ! -d $BACKUP_DIR ]
then
        mkdir -p "$BACKUP_DIR"
fi
echo "-----------START-----------" >> $LOGFILE
echo "BACKUP START DATE:" $(date +"%y-%m-%d %H:%M:%S") >> $LOGFILE


cd $BACKUP_DIR

rm -rf $DATE_DEP.sql.*

/usr/local/mysql/bin/mysqldump $OPTIONS | gzip > $DUMPFILE

if [[ $? == 0 ]]; then
  echo "[$ARCHIVE] Backup Successful!" >> $LOGFILE
else
  echo "Database Backup Fail!" >> $LOGFILE
fi


echo "BACKUP END DATE:" $(date +"%y-%m-%d %H:%M:%S") >> $LOGFILE
echo "Backup Process Done"
echo "---------END------------" >> $LOGFILE