#!/bin/bash
#********************************************************************
#Author: Merlin
#E-Mail: null
#Date: 2023-07-26
#FileName: backup.sh
#URL: null
#Description: The test script
#********************************************************************
#编写脚本,使用mysqldump实现分库分表备份。
#用户信息
user='-uroot -p1234'
#过滤无关数据库
egrepfile='information_schema|mysql|performance_schema|sys|Database'
#创建备份目录
path='/test/backup/'
mkdir -p ${path}>/dev/null
#显示普通用户可操作数据库
mysql ${user} -e 'show databases' 2>/dev/null | egrep -v ${egrepfile}>dbname
# echo `cat dbname`
while read db
do
#echo ${db}
mysql ${user} -e "show tables from ${db}" 2>/dev/null | egrep -v "Tables_in_${db}">table
while read tb
do
mysqldump ${user} ${db} ${tb} > "${path} ${tb}.sql" 2>/dev/null
done < table
done < dbname
rm dbname table
shell练习--编写脚本,使用mysqldump实现分库分表备份。
于 2023-07-26 22:31:10 首次发布