how to rename the database in mysql?

jayanagi

I need to change my database name is there any query or command for renaming the databse?

rincewind456

lisaNewbie

Hey-

I tried to use this command but it is not compatible with Server 5.0.5a. I am not comfortable with installing 5.1 just yet and wonder if you have any further suggestions for renaming a database.

Thanks!!

Lisa

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

rincewind456

This command is no longer valid as it has proven to be dangerous.

You need to use ALTER DATABASE syntax instead.

NogDog

You may end up having to simply create a new database with the desired name, then dump the current data to a .sql file and then load that .sql file into the new DB.

Or, you might decide the current name isn't all that bad after all. 😉