One of the routine tasks for a DBA is renaming database schemas,
and as such MySQL added a command to carry out that purpose
called “RENAME DATABASE <database_name>”. However this
command just made it through a few minor releases before being
discontinued (from MySQL 5.1.7 to 5.1.23). Here’s a link
to the reference manual regarding the command http://dev.mysql.com/doc/refman/5.1/en/rename-database.html.
Vadim wrote a MySQL Performance Blog post about this a few years
ago where he mentions the dangerous nature of this command – that
post was …

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.