>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Tuesday, May 24, 2011 11:52 AM
>To: Jerry Schwartz
>Subject: Re: Renaming a database?
>----- Original Message -----
>> From: "Jerry Schwartz" <jerry@stripped>
>> It looks like there's no way to rename a database. Is that true?
>Yes. Silly oversight, although there's probably complexity reasons behind it.
[JS] According to the documentation, this was implemented at one time but it
caused problems so the feature was removed.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>> - I want to get a current version of a database out of the way so
>> that I can load in an older version, without having to pay the
>> penalty of reloading the current version.
>That precludes "rename table db1.blah to db2.blah", I guess - it basically
>copies the whole thing and then kills the old one. Slowwwwww for big tables
>> - I think I have a database that isn't being used (don't ask), and I
>> want to hide it to see if anything blows up.
>If you are in a position to shut your server down, you may rename the
>directory while it's down IF you only use MyISAM tables.
>If you have InnoDB tables, you're stuck with dump/reload or rename table.
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel