Re: renaming a mysql database
There is unfortunately no way to rename a database. Apparently you used to be able to in older versions of MySQL, but it caused problems so that ability was removed.
If you really need to rename the databse, then your best bet is to export the data and then re-import it into the new empty database with the correct name.
--
Scott Nemes
MySQL DBA
http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes
Subject
Views
Written By
Posted
2204
May 04, 2012 05:59AM
Re: renaming a mysql database
1580
May 04, 2012 08:56AM
1042
May 05, 2012 01:38PM
1045
May 05, 2012 08:59PM
1377
May 07, 2012 04:09AM
Sorry, you can't reply to this topic. It has been closed.
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.