Rename mysql database

[Antarjot]

Does any one know the command to rename mysql database. I have created a database with name database1 and now i want to convert or change that name in to database2. What are syntax use in mysql to change the database name. I have tried to change that from command

rename database database TO database1

and it says its invalid syntax by database..

[Walby]

If you're renaming the DB by command line, you'll want to grant user permissions to the new DB and delete permissions granted for the old DB.you can just rename the folders that store the databases while the server is. But that doesn't work when you have at least one InnoDB table, because renaming folders wrecks the tablespace. But that does not work when you have at least one InnoDB tableYou either run an SQL query to do this or do it with phpMyAdmin if you don't want to bother remembering the SQL to do so.

[Zecho]

Use the following code to rename mysql database

mv databse databse1

cd database/

mv databse.frm database1.frm

mv databse.MYD database1.MYD

mv databse.MYI databse1.MYI

Restart MySQL

/etc/init.d/mysql start

[Aberto]

MySQL does not support a database rename command. If MySQL has no command for renaming a database then the safest way is to use mysqldump to back up the old database, then restore the dump. Using mysqldump, dump the database. The mysqldump client can be used to dump a database or a collection of databases for backup or for transferring the data to another SQL server.