At 11:01 +0530 10/11/02, Insanely Great wrote:
>Greetings...
>
>I dont think that there is any SQL statement to do that.
>
>As of changing the name, You can just go to the data directory of MySQL and
>change the name of the directory of the database. MySQL stores each database
>as a directoyr so c
> I dont think that there is any SQL statement to do that.
No, just use mysqldump to do it.
sql, query.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
SELECT INTO TABLE!
Simon
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 06:31
To: Scott Pippin; [EMAIL PROTECTED]
Subject: Re: copy one database to another
Greetings...
I dont think that there is any SQL statement to do that.
As of changing
Greetings...
I dont think that there is any SQL statement to do that.
As of changing the name, You can just go to the data directory of MySQL and
change the name of the directory of the database. MySQL stores each database
as a directoyr so changing the name of the directory will change the name