rename db

重命名库名,实际就是修改元数据信息

cat 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