#!/bin/bash
假设将sakila数据库名改为new_sakila
MyISAM直接更改数据库目录下的文件即可
mysql -uroot -p123456 -e ‘create database if not exists new_sakila’
list_table=$(mysql -uroot -p123456 -Nse “select table_name from information_schema.TABLES where TABLE_SCHEMA=‘sakila’”)
for table in
l
i
s
t
t
a
b
l
e
d
o
m
y
s
q
l
−
u
r
o
o
t
−
p
123456
−
e
"
r
e
n
a
m
e
t
a
b
l
e
s
a
k
i
l
a
.
list_table do mysql -uroot -p123456 -e "rename table sakila.
listtabledomysql−uroot−p123456−e"renametablesakila.table to new_sakila.$table"
done