询问 mysql的数据库 库名称如何更改

询问 mysql的数据库 库名称如何更改
（表名是很简单的）

---

尝试一下变通的方法：

创建一个新的数据库名称

备份要修改的数据库，把备份的数据还原到新建的数据库中

---

不过这个实时性不好，建议在数据库空闲的时候操作

---

直接rename 啊


12.1.32. RENAME DATABASE Syntax
RENAME {DATABASE | SCHEMA} db_name TO new_db_name;

This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23. It was intended to enable upgrading pre-5.1 databases to use the encoding implemented in 5.1 for mapping database names to database directory names (see Section 8.2.3, “Mapping of Identifiers to File Names”). However, use of this statement could result in loss of database contents, which is why it was removed. Do not use RENAME DATABASE in earlier versions in which it is present.

To perform the task of upgrading database names with the new encoding, use ALTER DATABASE db_name UPGRADE DATA DIRECTORY NAME instead (see Section 12.1.1, “ALTER DATABASE Syntax”).

---

RENAME TABLE tbl_name TO new_tbl_name
    [, tbl_name2 TO new_tbl_name2] ...

---

This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.2

---

引用

This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.2