From: Jorge Bastos
Date: October 13 2004 5:44pm
Subject: Re: Mysql
List-Archive: http://lists.mysql.com/dotnet/29
Message-Id: <035401c4b14c$42397870$0301a8c0@pcjorge>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 8bit

Great,

I'll be looking for it in the future.

Jorge

----- Original Message ----- 
From: "Reggie Burnett" <reggie@stripped>
To: "Jorge Bastos" <mysql.jorge@stripped>
Cc: <dotnet@stripped>
Sent: Monday, October 11, 2004 6:37 PM
Subject: Re: Mysql


>
> There may be an easier way, but in the future, we are hoping to have a 
> federated storage engine.  Using this, you would be able to "view" tables 
> on a remote database as if they are on a local database.  With this in 
> place, you could do a simple insert .. select ...
>
> -reggie
>
> Jorge Bastos wrote:
>
>>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
>>
>>
>>
>>
>