shell 分库分表备份
[root@master ~]# 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 d b n a m e > / t m p / 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 t a b l e > / t m p / table >/tmp/table>/tmp/dbname_$table.sql
done < /tmp/tables.txt
done
