shell 分库分表备份

shell 分库分表备份

[[email protected] ~]# cat mydump.sh
#!/bin/bash
mysqldump=“mysql -uroot -p123456 -S /tmp/mysql.sock1”
for dbname in $mysqldump -e "show databases" 2>/dev/null |egrep -v "Database|schema"
do
echo $dbname
#分库备份
mysqldump -uroot -p123456 -S /tmp/mysql.sock1 --databases $dbname > /tmp/$dbname>/tmp/dbname.sql
#分表备份
mysql -uroot -p123456 -S /tmp/mysql.sock1 -e “show tables from $dbname;” 2>/dev/null |sed ‘1d’ >> /tmp/tables.txt
while read table
do
echo $table
mysqldump -uroot -p123456 -S /tmp/mysql.sock1 $dbname $table >/tmp/$table>/tmp/dbname_$table.sql
done < /tmp/tables.txt
done