!/bin/sh

DB_NAME=””
DB_USER=””
DB_PASSWD=””

BIN_DIR=”/opt/lampp/bin/” # mysql 执行文件目录
TEMP_DIR=”/opt/lampp/db_backup/${DB_NAME}/”
BACKUP_DIR=”/opt/lampp/db_backup/${DB_NAME}_db_backup/”
DATE=date +%Y%m%d_%H%M%S

rm -rf ${TEMP_DIR}
[ -d ${TEMP_DIR} ] || mkdir ${TEMP_DIR}
[ -d ${BACKUP_DIR} ] || mkdir ${BACKUP_DIR}

delete files over 10 days

find ${BACKUP_DIR} -mtime +10 -exec rm -rf {} ;

back db

日志选项暂未打开 –flush-logs –master-data=2

${BIN_DIR}mysqldump -u${DB_USER} -p${DB_PASSWD} ${DB_NAME} –lock-all-tables > ${TEMP_DIR}db_backup_${DB_NAME}${DATE}.sql
cp ${TEMP_DIR}db_backup${DB_NAME}${DATE}.sql ${BACKUP_DIR}db_backup${DB_NAME}_${DATE}.sql