#!/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
脚本——获取数据库中所有的库
最新推荐文章于 2024-01-14 17:06:38 发布
#!/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