mysql数据库备份

最新推荐文章于 2025-09-08 20:55:49 发布

原创最新推荐文章于 2025-09-08 20:55:49 发布 · 146 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#linux系统管理 #数据库

#!/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 {} \;