mysql 如何重命名数据库？

cheungjustin

mysql 如何重命名数据库？
没有rename database a to b 这样的语法啊。

飞鸿无痕

回复 1# cheungjustin


    是myisam的话直接在系统层面更改该数据库文件夹的名字，注意做好备份。
最好是新建个数据库，导出原数据后，再导入。

cenalulu

回复  cheungjustin


    直接在系统层面更改该数据库文件夹的名字，注意做好备份。
最好是新建个数据 ...
飞鸿无痕 发表于 2010-11-10 09:41

    innodb不能直接更改数据库文件夹名字哈。。。

飞鸿无痕

回复 3# cenalulu


    谢谢，学习了，哈哈，没怎么用过innodb，以后多向你学习。如果是innodb的话有没有什么好的办法该更改数据库名呢？

strong_sjhi

有命令,但不推荐用.
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.

飞鸿无痕

有命令,但不推荐用.
RENAME {DATABASE | SCHEMA} db_name TO new_db_name;

This statement was added i ...
strong_sjhi 发表于 2010-11-10 10:25

试用过，没有一成更改成功过，呵呵！

ruochen

试用过，没有一成更改成功过，呵呵！
飞鸿无痕 发表于 2010-11-10 10:37

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

飞鸿无痕

谢谢楼上，明白了！

cheungjustin

回复 2# 飞鸿无痕


    系统层面怎么改啊，呵呵，俺最近刚开始学习mysql.
见笑了。

飞鸿无痕

回复 9# cheungjustin


    就是系统上执行mv命令嘛，哈哈