mysql数据库备份

 #!/bin/bash

DB_BACKUP_DIR="/data/db_backup"
[[ ! -d $DB_BACKUP_DIR ]] && mkdir -p $DB_BACKUP_DIR

DB_USER="root"
DB_PWD="xxx"
DB_CONNECT="/usr/local/mysql/bin/mysql -hlocalhost -u${DB_USER} -p${DB_PWD}"
#DB_DUMP_CONNECT="/usr/local/mysql/bin/mysqldump -hlocalhost -u${DB_USER} -p${DB_PWD} --dump-slave=2"
DB_DUMP_CONNECT="/usr/local/mysql/bin/mysqldump -hlocalhost -u${DB_USER} -p${DB_PWD} --single-transaction --master-data=2"

DB_ARRAY=(`${DB_CONNECT} -N  -e "show databases" | grep -Ev "information_schema|mysql|performance_schema"`)
#echo ${DB_ARRAY[@]}

for db in ${DB_ARRAY[@]}
do
        backup_time=`date +%Y%m%d`
        ${DB_DUMP_CONNECT} $db > ${DB_BACKUP_DIR}/$db.${backup_time}.sql
done


find $DB_BACKUP_DIR/ -type f -mtime +30 -exec rm -f {} \;