Modify the MySQL database name

The principle of modification is to create a new database and then rename all the tables. Just look at the script below. I'm going to change the name of the download database to DOWNLOADV2.

#!/bin/bashmysql-uroot-p1q2w3e4r-e ' CREATE database if not exists Downloadv2 ' list_table=$ (mysql-uroot-p1q2w3e4r-nse "SELECT table_name from INFORMATION_SCHEMA. TABLES where table_schema= ' Download ' ") for table in $list _tabledomysql-uroot-p1q2w3e4r-e" rename TABLE download. $table t o downloadv2. $table "Done

This article is from the "technology for the King" blog, please be sure to keep this source http://wangzhenyu.blog.51cto.com/2996939/1660544

Modify the MySQL database name