Nevermind -- it's working absolutely perfectly between 5.5.8 and 4.1.x. Thanks again for the push.
-Hank On Tue, Jan 4, 2011 at 5:14 PM, Hank <hes...@gmail.com> wrote: > > 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 >> > >
