List:General Discussion« Previous MessageNext Message »
From:Octavian Rasnita Date:October 17 2005 11:56am
Subject:Re: renaming the database
View as plain text  
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.

Thread
renaming the databaseOctavian Rasnita16 Oct
  • Re: renaming the databaseJigal van Hemert17 Oct
  • Re: renaming the databaseOctavian Rasnita17 Oct
  • Re: renaming the databaseC.R. Vegelin17 Oct
    • Re: renaming the databaseJigal van Hemert17 Oct
  • Re: renaming the databaseRobert L Cochran17 Oct
    • Re: renaming the databaseSGreen17 Oct
      • Re: renaming the databaseRobert L Cochran17 Oct
        • Re: renaming the databaseSGreen17 Oct
          • Re: renaming the databasePeter Brawley17 Oct
      • Re: renaming the databasePeter Brawley17 Oct
  • Re: renaming the databaseGleb Paharenko17 Oct