List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:May 24 2011 6:40pm
Subject:RE: Renaming a database?
View as plain text  
>-----Original Message-----
>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Tuesday, May 24, 2011 11:52 AM
>To: Jerry Schwartz
>Cc: mysql@stripped
>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.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
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 
>database
>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



Thread
Renaming a database?Jerry Schwartz24 May
  • Re: Renaming a database?Andrew Moore24 May
    • RE: Renaming a database?Jerry Schwartz24 May
    • RE: Renaming a database?Daevid Vincent24 May
  • Re: Renaming a database?Johan De Meersman24 May
    • RE: Renaming a database?Jerry Schwartz24 May
  • Re: Renaming a database?Andrew Moore24 May
    • RE: Renaming a database?Jerry Schwartz24 May