Regular backup of mysql database (retain backups for nearly 7 days)

#!/bin/bash# File: mysql_backup.sh# Usage: bash mysql_backup.sh# Description: Backup mysql all databases. Exclude the following databases: information_schema|binlogs|mysql|test|Database|performance_schema|hive# CRONTAB: Backup data every 23:00# 00 23 * * * bash /data/app/mysql/scripts/mysql_backup.shBACKUP_DIR="/data/appData/backup/mysql"MYSQL_BIN="/data/app/mysql/bin/mysql"MYSQL_DUMP="/data/app/mysql/bin/mysqldump"MYSQL_IP="127.0.0.1"MYSQL_PORT=3306MYSQL_USER="username"MYSQL_PWD="password"CLEAR_INTERVAL=7if [[ ! -d $BACKUP_DIR ]]; thenmkdir -p $BACKUP_DIRfiif [ "x$MYSQL_PWD" == "x" ]; then$MYSQL_BIN -P$MYSQL_PORT -u$MYSQL_USER -h$MYSQL_IP -e 'exit' >/dev/null 2>&1else$MYSQL_BIN -P$MYSQL_PORT -u$MYSQL_USER -p$MYSQL_PWD -h$MYSQL_IP -e 'exit' >/dev/null 2>&1fiif [ $? -ne 0 ]; thenecho "Error: MySQL User and Password Error."exit 1finowTime=$(date +%Y%m%d%H%M)if [ "x$MYSQL_PWD" == "x" ]; thendatabases=$($MYSQL_BIN -u$MYSQL_USER -h$MYSQL_IP -P$MYSQL_PORT -e 'show databases;' 2>/dev/null | egrep -v 'information_schema|binlogs|mysql|test|Database|performance_schema|hive')elsedatabases=$($MYSQL_BIN -u$MYSQL_USER -p$MYSQL_PWD -h$MYSQL_IP -P$MYSQL_PORT -e 'show databases;' 2>/dev/null | egrep -v 'information_schema|binlogs|mysql|Database|performance_schema|hive')fifor dataName in $databases; doif [ "x$MYSQL_PWD" == "x" ]; then$MYSQL_DUMP --single-transaction -P$MYSQL_PORT -u$MYSQL_USER -h$MYSQL_IP -a --default-character-set=utf8 --skip-comments $dataName 2>/dev/null | gzip -n >$BACKUP_DIR/$dataName-$nowTime.sql.gzelse$MYSQL_DUMP --single-transaction -P$MYSQL_PORT -u$MYSQL_USER -p$MYSQL_PWD -h$MYSQL_IP -a --default-character-set=utf8 --skip-comments $dataName 2>/dev/null | gzip -n >$BACKUP_DIR/$dataName-$nowTime.sql.gzfidonefind $BACKUP_DIR -type f -name *.sql.gz -mtime ${CLEAR_INTERVAL} | xargs rm -rf