Re: Rename database

[tom corcoran]

Daniel Dinnie Wrote:
-------------------------------------------------------
> This statement was added in MySQL 5.1.7 but was
> found to be dangerous and was removed in MySQL
> 5.1.23
>
> To perform the task of upgrading database names
> with the new encoding, use ALTER DATABASE db_name
> UPGRADE DATA DIRECTORY NAME instead

I'm not sure why this whole database renaming for the current version is so cloak and dagger. The manual gives no example. Please can you give an example using old_dbname and new_db_name of how this is achieved.