Rename mysql database

--=_3dr1bcw7wbb4
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


Hi All,

I want to rename my database. but as per the mysql documentation it says, RENAME DATABASE command has been removed from mysql 5.1.

Can anyone help me with this, that is there any other way I can rename it.

Thanks in advance.

--
Regards,
Manasi Save


--=_3dr1bcw7wbb4
Content-Type: multipart/related;
boundary="=_3g5tyzzncbi8";
start="3g6ot78l2h4w@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_3g5tyzzncbi8
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 3g6ot78l2h4w@mail.artificialmachines.com

Hi All,

I want to rename my database. but as per the mysql
documentation it says, RENAME DATABASE command has been removed from mysql
5.1.

Can anyone help me with this, that is there any other
way I can rename it.

Thanks in advance.

--

Regards,

Re: Rename mysql database

--00504502b535763c99047ca6264d
Content-Type: text/plain; charset=ISO-8859-1

You can try this one.

http://preetul.wordpress.com/2009/07/27/rename-database-in-m ysql/

Note: I have not tested.

On Fri, Jan 8, 2010 at 5:04 PM, Manasi Save <
manasi.save@artificialmachines.com> wrote:

> Hi All,
>
>
> I want to rename my database. but as per the mysql documentation it says,
> RENAME DATABASE command has been removed from mysql 5.1.
>
>
> Can anyone help me with this, that is there any other way I can rename it.
>
>
> Thanks in advance.
>
>
> --
>
> Regards,
> Manasi Save
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--00504502b535763c99047ca6264d--