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
