>-----Original Message----- >From: Andrew Moore [mailto:eroomy...@gmail.com] >Sent: Tuesday, May 24, 2011 11:31 AM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Renaming a database? > >Instead of renaming it, revoke permissions to it. If it's being used you >should see some problems in the application due to access denied. > [JS] That's a good suggestion. It takes care of one case, but not the other.
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 >Andy > >On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz <je...@gii.co.jp> wrote: > >> It looks like there's no way to rename a database. Is that true? >> >> >> >> I have two reasons for wanting to do this: >> >> >> >> - 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. >> >> - 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. >> >> >> >> Suggestions? >> >> >> >> Regards, >> >> >> >> Jerry Schwartz >> >> Global Information Incorporated >> >> 195 Farmington Ave. >> >> Farmington, CT 06032 >> >> >> >> 860.674.8796 / FAX: 860.674.8341 >> >> E-mail: <mailto:je...@gii.co.jp> je...@gii.co.jp >> >> Web site: <http://www.the-infoshop.com/> www.the-infoshop.com >> >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org