MySQL 5.1 Reference Manual  /  ...  /  RENAME DATABASE Syntax

13.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 9.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 13.1.1, “ALTER DATABASE Syntax”).

User Comments
  Posted by Ilan Hazan on December 28, 2010
This command is only available from MySQL versions >=5.1.
For older versions you can:
1. Rename all tables to be in the new database
2. Use mysqldump to dump the database data into a file and then apply it to a new database.
For more information see

Sign Up Login You must be logged in to post a comment.