Thanks. I want to rename the database in order to keep it as a backup, then to temporarily create a new one with the same name as a test, because more programs use that database name.
Teddy ----- Original Message ----- From: "Jigal van Hemert" <[EMAIL PROTECTED]> To: "Octavian Rasnita" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Monday, October 17, 2005 12:11 PM Subject: Re: renaming the database > Octavian Rasnita wrote: > > Is there a command for renaming a MySQL database? > > Sorry, there is no command for that. For small databases you can use > administration tools like phpMyAdmin, etc. which will do it for you by > duplicating the database structure and data, and then drop the 'old' > database. For big databases this will take quite long, so it's probably > better to stick with the old name (what's in a name? ;-) ) > > Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]