Or, use mysqldump to dump the entire database, edit the CREATE DATABASE line at the top to the new name and pipe it all back into mysql, then drop the old one?
-ravi -----Original Message----- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: October 3, 2001 11:50 AM To: Brandon Lewis; [EMAIL PROTECTED] Subject: RE: Is it possible to Rename Database > Is it possible to rename a database? I would assume that the only way to do is is to shut down the server, then rename the directory of the database. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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