Hi! >> Can you rename a database? If so, how does it handle all the >> tables inside it? > >By shutting down the server, renaming the directory >of that database and restarting the server. > >The server will be able to handle the change just fine.
Sorry, but InnoDB tables do not get renamed inside the internal data dictionary of InnoDB this way. For them currently the way is, for exapmle, to create the tables to the new database and use INSERT INTO new_database.table1 SELECT * FROM old_database.table1. >/ Carsten >-- >Carsten H. Pedersen >keeper and maintainer of the bitbybit.dk MySQL FAQ >http://www.bitbybit.dk/mysqlfaq Regards, Heikki http://www.innodb.com/ibman.html --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php