MySQL Forums
Forum List  »  Newbie

Re: Rename a Database - How?
Posted by: Harsha Chaithanya K
Date: August 27, 2004 07:22AM

Hi there,

U cant directly rename a database in Mysql front.

U can do it round about. But am not sure if all the previliges/grants/´ets works well doing so.

Create a new database with the required name.

export all ur tables to the new Database

delete the old one.

Another way of doing this is:

Stop MySql and rename the folder holding the database files using DOS/Explorer/Bash

Hope this helps you.

Options: ReplyQuote


Subject
Written By
Posted
August 26, 2004 05:54AM
Re: Rename a Database - How?
August 27, 2004 07:22AM
August 30, 2004 02:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.