Renaming Database

[tobyheywood]

Hi,

Just a quickie (hopefully) I have a database with a reasonable amount of data contain within its tables. I have a requirement to rename the database so that it matches that of my ISP provided database. Is there a command or tool which could be used to rename the database which will leave the content intact?

I know that I can mysqldump to dump all data then create a new database to house the data but if possible I would like to be able to rename the database!

Thank you in advance.

Regards


Toby Heywood

 

[hvass]

stop the server
rename the directory
start the server