MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Simon Green Date:October 11 2002 8:25am
Subject:RE: copy one database to another
View as plain text  
SELECT INTO TABLE!
Simon

-----Original Message-----
From: Insanely Great [mailto:insanely420@stripped]
Sent: 11 October 2002 06:31
To: Scott Pippin; mysql@stripped
Subject: Re: copy one database to another


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 of
the database.

I have tried this with MyISAM and ISAM tables, not sure of other table
types.

Rgds
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog

----- Original Message -----
From: "Scott Pippin" <spippin@stripped>
To: <mysql@stripped>
Sent: Friday, October 11, 2002 4:25 AM
Subject: copy one database to another


> I have one database(test) i would like to copy over to (test1).  Ehat is
> the syntax to do this?  Is there any to just change the name of the
> database?
>
> Thanks in advance
> (query, mysql)
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread121881@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-insanely420=punkass.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread121899@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-sgreen=eurobell.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
copy one database to anotherScott Pippin11 Oct
  • Re: copy one database to anotherInsanely Great11 Oct
    • RE: copy one database to anotherEd Carp11 Oct
    • Re: copy one database to anotherPaul DuBois12 Oct
RE: copy one database to anotherSimon Green11 Oct