No... I've pretty much avoided those. This WAS a Visual FoxPro app so we're still at the stage where we really aren't "leveraging" MySQL specific features. We're still pretty much just eliminating VFP specific things.
Hence the one time nature of this renaming. Now that we're 5-10 customers in to upgrading we decided to actually define a naming convention for the databases themselves so I've got to fix the 5-10 that are already out there (I could not change it... but then we have to "remember" that these are special cases) On Wed, Aug 19, 2009 at 10:28 AM, Rolando Edwards<redwa...@logicworks.net> wrote: > If you have stored procedures, don't forget to update the db column with the > new db in mysql.proc as that does not automatically change. > > Rolando A. Edwards > MySQL DBA (CMDBA) > > 155 Avenue of the Americas, Fifth Floor > New York, NY 10013 > 212-625-5307 (Work) > 201-660-3221 (Cell) > AIM & Skype : RolandoLogicWorx > redwa...@logicworks.net > > -----Original Message----- > From: Matt Neimeyer [mailto:m...@neimeyer.org] > Sent: Wednesday, August 19, 2009 9:27 AM > To: Paul DuBois > Cc: mysql@lists.mysql.com > Subject: Re: Renaming a Database > >>> That said... Is there anything "wrong" (dangerous, disasterous, etc) >>> with stopping the MySQL service and renaming the folder in the MySQL >>> data folder? By my logic (if I'm right) this should preserve any >>> permissions on the folder and since the service is stopped it should >>> simply find the new instance. > >> If you have InnoDB tables, there will be a problem. InnoDB maintains the >> database name in the shared tablespace, and it will no longer be able to >> find those tables. > > Nope. These are entirely MyISAM tables... So I will probably give this > a try then. > > Matt > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
