List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 29 2002 10:12pm
Subject:RE: exporting data to a new DB
View as plain text  
At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote:
>Hello everyone,
>I need to export some data from one DB to another.
>Suppose I'm connected to DB1 and my trying to get stuff from there 
>and insert into DB2.  I'm using Insert Select statements.  Once I'm 
>connected to DB1, do I have to establish separate connection for DB2?

Not if they're both hosted by the same MySQL server.

And if they're not, you can't do this anyway. :-)

>An example Insert Select :  Insert into db2.Pad_Analysis_Data 
>(column names) Select * from db1.Pad_Analysis_Data;
>Oganes Demirchyan
>Motorola Life Science
>757 S.Raymond
>Pasadena, CA  91105
>Tel: 626-584-5900
>email: Oganes.Demirchyan@stripped

RE: exporting data to a new DBDemirchyan Oganes-AOD09829 Jan
RE: exporting data to a new DBPaul DuBois29 Jan