Centos7中实现脚本使用mysqldump实现分库分表备份

脚本

#!/bash/bin
user=root      #用户名
password=123456   #密码
back_path=/backup/db
databases_file=/backup/databases.list
[ -f $databases_file ] || touch /backup/databases.list
if [[ ! -s ${databases_file} ]]
then
while read line
do
  [ -d ${back_path}/$line ] || mkdir -p ${back_path}/$line
 mysqldump -u${user} -p${password} -B $line 2>/dev/null | gzip 1> ${back_path}/${line}/${line}.sql.gz
  mysql -u$user -p$password -N -e "show tables from $line" 1> /backup/tbname 2>/dev/null
 while read tb
 do
  mysqldump -u${user} -p${password} $line $tb 2>/dev/null | gzip 1>${back_path}/$line/${line}_${tb}.sql.gz
 done < /backup/tbname
done < $databases_file
if [ $? -eq 0 ]
then
  echo "备份成功！！备份目录是$back_path"
else
  echo "备份失败！！！请检查"
fi
rm -rf /backup/tbname
true > $databases_file

 执行脚本

备份成功！