1、分庫備份
[root@localhost mysql-backup]# cat db_bak.sh
#!/bin/bash
k_user=root
bak_password=123456
bak_path=/root/mysql-backup/
bak_cmd="-u$bak_user -p$bak_password"
exc_db="Database|information_schema|mysql|performance_schema|sys"
dbname=`mysql $bak_cmd -e "show databases"| egrep -v $exc_db`
for db in `echo $dbname`
do
[ -d $bak_path ] || mkdir -p $bak_path
mysqldump $bak_cmd -B $db | gzip > $bak_path/${db}_`date +$Y%m%d`.sql.gz
done2、分表備份
[root@localhost mysql-backup]# cat tb_bak.sh
#!/bin/bash
k_user=root
bak_password=123456
bak_path=/root/mysql-backup/
bak_cmd="-u$bak_user -p$bak_password"
exc_db="Database|information_schema|mysql|performance_schema|sys"
db_name=`mysql $bak_cmd -e "show databases"| egrep -v $exc_db`
#echo $db_name
for db in `echo $db_name`
do
[ -d ${bak_path} ] || mkdir -p ${bak_path}
dt_name=`mysql $bak_cmd -e "use $db;show tables" | egrep -v "Tables_in_$db"`
#echo $db
#echo $dt_name
for dt in `echo $dt_name`
do
#echo $db $dt
mysqldump $bak_cmd $db ${dt} | gzip > $bak_path/${db}_${dt}.`date +%F%m%d`.sql.gz
done
done3、運行截圖
?文章來源地址http://www.zghlxwxcb.cn/news/detail-615313.html
文章來源：http://www.zghlxwxcb.cn/news/detail-615313.html
到了這里，關(guān)于MySQL 實現(xiàn)分庫和分表的備份 2023.7.29的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
