MySQL 实现分库和分表的备份 2023.7.29

最新推荐文章于 2024-09-28 10:22:29 发布

那年遇见了你

最新推荐文章于 2024-09-28 10:22:29 发布

阅读量1k

点赞数

分类专栏：数据库文章标签： adb android

本文链接：https://blog.csdn.net/z1711582538/article/details/131995770

版权

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
done

2、分表备份

[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