[root@DB script]# cat getdb.sh
#!/bin/bash
mysql -uroot -proot "-BNe show databases;"|grep -v "information_schema"|grep -v "performance_schema" >aa.txt
x=`cat aa.txt`
for i in $x
do
mysqldump -proot --opt $i>$i.sql
done
#!/bin/bash
mysql -uroot -proot "-BNe show databases;"|grep -v "information_schema"|grep -v "performance_schema" >aa.txt
x=`cat aa.txt`
for i in $x
do
mysqldump -proot --opt $i>$i.sql
done