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