>-----Original Message----- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >Sent: Tuesday, May 24, 2011 11:52 AM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Renaming a database? > >----- Original Message ----- >> From: "Jerry Schwartz" <je...@gii.co.jp> >> >> 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: je...@gii.co.jp 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
