#
# crontab部署
# 0 3 * * * sh /opt/dump/script/backup-mysql.sh > /dev/null
#

#!/bin/bash
#备份名录
MYSQLDUMP="/usr/bin/mysqldump"
BACK_DIR="/opt/dump"
DB_hostname="127.0.0.1"
DB_user="dbuser"
DB_password="dbpasswd"
DB_name="dbname"
TIME_NOW=`date +%Y-%m-%d-%H%M%S`
BKUP_LOG="/opt/dump/log/`date +%Y%m`_db.log"
BKUP_FILE_NAME=${BACK_DIR}/${TIME_NOW}-${DB_name}
BKUP_DELE=`date -d '10 days ago' '+%Y%m%d'`

echo ${TIME_NOW} >> ${BKUP_LOG}
echo "=======Start Backup=========" >> ${BKUP_LOG}
${MYSQLDUMP} -h ${DB_hostname} -u${DB_user} -p${DB_password} --databases ${DB_name} > ${BKUP_FILE_NAME}.sql
echo 'generate sql file : '${BKUP_FILE_NAME}.sql >> ${BKUP_LOG}
tar cvzf ${BKUP_FILE_NAME}.tar.gz -C ${BACK_DIR}  ${TIME_NOW}-${DB_name}.sql
echo 'tar...'${BKUP_FILE_NAME}.tar.gz >> ${BKUP_LOG}
/bin/rm -f ${BKUP_FILE_NAME}.sql
echo 'DELETE '${BKUP_FILE_NAME}'.sql' >> ${BKUP_LOG}
/bin/rm -f ${BACK_DIR}/${BKUP_DELE}*.gz >> ${BKUP_LOG}
echo "=======Finished Backup======" >> ${BKUP_LOG}
echo "" >> ${BKUP_LOG}
echo "" >> ${BKUP_LOG}