#!/bin/bash
# 假设将sakila数据库名改为new_sakila
# MyISAM直接更改数据库目录下的文件即可

mysql -uroot -pXTZ@shop@951688 -e 'create database if not exists xyzshopold'
list_table=$(mysql -uroot -pXTZ@shop@951688 -Nse "select table_name from information_schema.TABLES where TABLE_SCHEMA='xyzshop'")

for table in $list_table
do
    mysql -uroot -pXTZ@shop@951688 -e "rename table xyzshop.$table to xyzshopold.$table"
done