Re: copy one database to another

2002-10-12 Thread Paul DuBois
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

RE: copy one database to another

2002-10-11 Thread Ed Carp
> 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

RE: copy one database to another

2002-10-11 Thread Simon Green
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

Re: copy one database to another

2002-10-11 Thread Insanely Great
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