MySQL Bugs: #58592: RENAME DATABASE statement

Bug #58592	RENAME DATABASE statement
Submitted:	30 Nov 2010 15:50
Reporter:	Matthew Lord	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	all, 8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We don't have a RENAME DATABASE command.  This would be helpful in certain circumstances.

How to repeat:
N/A

Suggested fix:
implement the RENAME DATABASE SQL statement

This feature is supported in PostgreSQL
http://www.postgresql.org/docs/9.0/interactive/sql-alterschema.html

For Oracle Database this is not supported, The Enhancement Request number is 158508. 

Sybase ASE uses sp_renamedb.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1550/html...

Bug #106321 marked as duplicate of this one