From: Daevid Vincent
Date: May 24 2011 8:41pm
Subject: RE: Renaming a database?
List-Archive: http://lists.mysql.com/mysql/225097
Message-Id: <05a701cc1a52$fb678e10$f236aa30$@daevid.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
> -----Original Message-----
> On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz =
wrote:
>=20
> > It looks like there=E2=80=99s no way to rename a database. Is that =
true?
I know. Retarded right? Version 5.1.x and still what would seem the most =
basic of tasks is still impossible.=20
Maybe Oracle can fix what MontyAB and Sun couldn't... that feature alone =
would be well worth the $5.6 Billion dollars spent.
I just had a need to do this last week and was astonished to find it's =
still not implemented after all these... well ever! I unfortunately had =
to dump the database to a .sql file, edit said file, re-dump in, then =
dump in the new database, then run a SQL diff tool to find out what =
schemata and data was different. The whole process delayed me a few =
hours that I didn't budget for. Talk about a hindrance.=20
-----
And before anyone gets all upset with my use of the word "Retarded"...
Read this: http://dev.mysql.com/doc/refman/5.1/en/rename-database.html
And then the definition:
re=E2=80=A2tard=E2=80=A2ed
=E2=80=93verb (used with object)
1. to make slow; delay the development or progress of (an action, =
process, etc.); hinder or impede.
=E2=80=93verb (used without object)
2. to be delayed.