mysql的数据库备份脚本

shell脚本数据库备份

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