Re: Mysql

[Reggie Burnett]

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
>
>
>
>  
>