Also, can I do this: insert into federated_table select * from local_table?
-Hank On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> wrote: > On 1/4/2011 15:53, Hank wrote: > >> Hello, >> >> I have a background process that runs as a combination of PHP&MySQL. >> The >> end results are records in a table on server #1 (but not the entire table, >> just a small subset of the table needs to move). What's the >> easiest/cleanest way of moving those records to an identical table on >> another server? In Oracle, we used to be able to set up connection >> profiles >> and move data between servers with SQL, but I'm guessing that's not easy >> to >> do with MySQL. I'd prefer not to use mysql command line client commands >> to >> save the data as an OS file and then import that into the other server >> using >> another mysql command line client command. I'd like to find something >> cleaner than that. >> >> I'm using 5.5.8. >> >> thanks, >> >> -Hank >> >> Have you looked at the FEDERATED storage engine? > http://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html > > -- > Shawn Green > MySQL Principal Technical Support Engineer > Oracle USA, Inc. > Office: Blountville, TN >