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 $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/$dbname_$table.sql
	done < /tmp/tables.txt

done