List:General Discussion« Previous MessageNext Message »
From:Robert L Cochran Date:October 17 2005 11:37am
Subject:Re: renaming the database
View as plain text  
I think you can just rename the directory that that database lives in. 
If you read the documentation for CREATE DATABASE in dev.mysql.com, 
you'll see they discuss renaming the directory (although it does not 
directly say this can be done to rename the database, but it comes 
really close to that.) Based on the documentation the database name is 
simply a directory name, no more and no less.

Renaming tables has its own command syntax, you can look it up.

Bob Cochran



Octavian Rasnita wrote:

>Hi,
>
>Is there a command for renaming a MySQL database?
>
>Thank you.
>
>Teddy
>
>
>
>  
>

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