mysql分库分表备份

最新推荐文章于 2024-10-17 17:40:04 发布

巧手妙琢

最新推荐文章于 2024-10-17 17:40:04 发布

阅读量604

点赞数

分类专栏： linux 文章标签： mysql

本文链接：https://blog.csdn.net/weixin_54632015/article/details/112851869

版权

linux 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

mysql分库分表备份

#!/bin/bash
user="root"
password="123456"
mycmd="mysql -u$user -p$password -h 192.168.100.1"
mydump="mysqldump -u$user -p$password -h 192.168.100.1 --lock-tables=0"

for dbname in `$mycmd -e "show databases;"|egrep -v "Database|schema"`

do
  [ -d /opt/$dbname ]||mkdir -p /opt/$dbname
  for tabname in `$mycmd -e "show tables from $dbname"|sed 1d`
  do $mydump $dbname $tabname > /opt/$dbname/${tabname}_$(date +%F).sql
  done
done