Skip to content

Instantly share code, notes, and snippets.

@fteem

fteem/gist:1470124

Created December 13, 2011 02:10
Show Gist options
  • Save fteem/1470124 to your computer and use it in GitHub Desktop.
Save fteem/1470124 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment