批量备份与恢复mysql数据库

批量备份到/home/bak/mysql目录,注意需要输入mysql的root密码

mkdir -p /home/bak/mysql;
read -p '[Notice] Please input Mysql root passwd:' Mysqlpd;
[ "$Mysqlpd" == '' ] && InputMysqlpd;
db=mysql -uroot -p$Mysqlpd -e "show databases"|egrep -v "mysql|information_schema|performance_schema"|grep -v "Database"
for mysqldb in $db
do
mysqldump -uroot -p$Mysqlpd $mysqldb > /home/bak/mysql/$mysqldb
done

批量恢复

for mysqlmr in ls /home/bak/mysql; do
mysql -uroot -p$Mysqlpd $mysqlmr < /home/bak/mysql/$mysqlmr
done