数据库重命名

#!/bin/bash
# 假设将appdb数据库名改为appdb_2


mysql -uroot -p123456 -e 'CREATE DATABASE if NOT EXISTS appdb_2'
list_table=$(mysql -uroot -p123456 -Nse "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='appdb'")

for table in $list_table
do
    mysql -uroot -p123456 -e "RENAME TABLE appdb.$table TO appdb_2.$table"
done

mysql -uroot -p123456 -e "DROP  DATABASE appdb;"