Rename/Create Database from Existing Database

[chz013]

Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?

Any help is appreciated.
Thanks

 

[sleipnir214]

To my knowledge, there is no MySQL query which will rename a database.

Since with MySQL a database maps to a directory on the filesystem, one shortcut workaround is to create a new empty database, then copy the files from the old database's directory into the new database's directory.

Here's the gotchas:
1. I strongly recommend that you have MySQL shut down for the copy operation.
2. You need to make sure that the permissions on the copied files are correct. You haven't specified your OS, but on Linux the files must be owned by the user and group as which MySQL runs, with permissions 660.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[chz013]

sleipnir214
Thanks for the response.
could you elaborate more with details on the gotchas ?


Also, how do u use mysqlhotcopy ?

 

[sleipnir214]

Not much to say.

MySQL may react better if you create the new database, then shut MySQL down, then copy the old database table files to the new database directory.

And if the permissions aren't right on the files, MySQL will likely barf.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!