mysql备份脚本

#!/bin/bash
#db 备份
:<<eof
for db in `mysql -e "show databases"|egrep -v "Databases|schema"`
do
	#echo $db
	mysqldump --databases $db >/tmp/$db.sql
done
eof
#table 备份
mysql -e "show tables from mysql"|sed '1d'>>/tmp/mysql.txt
while read line
do
	if [ ! -d /tmp/mysql ]; then
			mkdir /tmp/mysql
	fi
	mysqldump mysql $line >/tmp/mysql/$line.sql
done < /tmp/mysql.txt