学无止境·运维高阶③（Mysqldump脚本）

1、详细脚本

#!/bin/bash
mysql_cmd=‘-uroot -pRedHat@123’
exclude_db=‘information_schema|performance_schema|sys’
bak_path=/backup/db
mysql $mysq{l}_{c}md-e^{\prime }showdatabase{s}^{\prime }-N|egrep-v"${exclude_db}" > dbname
while read line
do
[ -d $ba{k}_{p}ath/$line ] || mkdir -p $ba{k}_{p}ath/$line
mysqldump ${mysql_cmd} --set-gtid-purged=OFF -B $line | gzip > $ba{k}_{p}ath/${line}/KaTeX parse error: Expected group after '_' at position 7: {line}_̲(date +%F).sql.gz
mysql -uroot -pRedHat@123 -N -e “show tables from $line” > tbname
while read tb
do
mysqldump ${mysql_cmd} --set-gtid-purged=OFF $line $tb | gzip > $ba{k}_{p}ath/$line/KaTeX parse error: Expected group after '_' at position 7: {line}_̲{tb}_$(date +%F).sql.gz
done < tbname
done < dbname
rm -f dbname tbname

2、执行

sh -n back_db_v1.sh
rm -rf /backup/
sh back_db_v1.sh