修改库名

新建库名,然后通过脚本rename table

相当于做了数据字典的修改，建议非在线操作,原来db1中数据文件会自动移动到db2中

create database school_remove;

vi  remove_dbname.sh
list_table=$(/apps/svr/mysql57/bin/mysql -uroot -p -S /tmp/mysql3306.sock   -Nse "select table_name from information_schema.TABLES where TABLE_SCHEMA='school'")
for tbname in $list_table
do
    /apps/svr/mysql57/bin/mysql  -uroot -p -S /tmp/mysql3306.sock -e "rename table school.$tbname to school_remove.$tbname"
done