From: Jorge Bastos
Date: October 7 2004 9:17pm
Subject: Re: Mysql
List-Archive: http://lists.mysql.com/dotnet/22
Message-Id: <006c01c4acb3$1bb4e560$0101a8c0@jorge>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Well, i was thinking and .. i can do it with, connection to the first
server, and pass the select output to an ascii file with outfile, and in the
2nd server load the values with the load data statment, like this:

SELECT * INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ',' FROM table2;

LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY ',';


Tks anyway all :)
Jorge


----- Original Message ----- 
From: "Tobias Schittkowski" <tobias@stripped>
To: "'Jorge Bastos - Decimal'" <jorge@stripped>
Sent: Thursday, October 07, 2004 10:11 PM
Subject: AW: Mysql


There is a good GUI tool for this...  www.webyog.com

-----Ursprüngliche Nachricht-----
Von: Jorge Bastos - Decimal [mailto:jorge@stripped]
Gesendet: Donnerstag, 7. Oktober 2004 22:53
An: dotnet@stripped
Betreff: Mysql

Howdy,

One think if anyone knows or can give me an idea, Is it possible to transfer
data from one mysql server to another? for example (i know that this is not
possible in this way, but'll help to understand)

mysql> insert into server1.database.table select * from
mysql> server2.database.table

I mean, insert values in a table with a select from other server, in read
time, or even in other way.

Jorge Bastos