#!/bin/bash
db=`mysql -uroot -p123456 -e "show databases"|egrep -v "mysql|information_schema|performance_schema"|grep -v "Database"`

for line in $db:
do
  mysqldump -uroot -p123456 $line > $line.sql
done

MySQL备份每一个数据库为单独的sql文件