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" <jigal@stripped>
To: "Octavian Rasnita" <orasnita@stripped>
Cc: <mysql@stripped>
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.
