mysqldump分库分表备份脚本

利用SHELL脚本实现分库分表

#!/bin/bash
 
user='-uroot -pRedHat@123'
exclude_db="mysql|information_schema|performance_schema|sys|Database"
bak_path=/backup/
[  -d $bak_path ] ||  mkdir -p $bak_path
mysql $user -e 'show databases;' | egrep -v $exclude_db > db_bak
 
while read line
do
        mkdir -p $bak_path$line
        mysql -uroot -pRedHat@123 -N -e "show tables from $line" > db.table
        while read table 
        do
                mysqldump $user $line $table | gzip > $bak_path$line/$table`date +%F`.gz
        done < db.table
        rm -rf db.table
done < db_bak
 
rm -rf db_bak