On Aug 17, 2009, at 4:22 PM, Matt Neimeyer wrote:
I know the "best" way to rename a database is to use mysqldump, extract the database and then reload to the new database. (At least based on what I can find in the "12.1.32. RENAME DATABASE Syntax" section of the documentation) 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.
-- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
