文章目录
重命名数据库
#!/bin/bash
mysql_user="user"
mysql_pass="password"
mysql_host="192.168.1.1"
mysql_port="3306"
mysql_conn="mysql -u${mysql_user} -p${mysql_pass} -h${mysql_host} -P${mysql_port}"
olddb="old_name"
newdb="new_name"
$mysql_conn -e "CREATE DATABASE $newdb"
params=$($mysql_conn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='$olddb'")
for name in $params; do
$mysql_conn -e "RENAME TABLE $olddb.$name to $newdb.$name";
done;
$mysql_conn -e "DROP DATABASE $olddb"