Wow, that might just work! I've seen "Federated" tables mentioned about,
but I never knew that's what they are here for.. thanks.
Can I have a host (remote) table on a MySQL 4.1.x server, and the federated
table on a 5.5.8 server?
On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) <
> On 1/4/2011 15:53, Hank wrote:
>> I have a background process that runs as a combination of PHP&MySQL.
>> 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
>> and move data between servers with SQL, but I'm guessing that's not easy
>> do with MySQL. I'd prefer not to use mysql command line client commands
>> save the data as an OS file and then import that into the other server
>> another mysql command line client command. I'd like to find something
>> cleaner than that.
>> I'm using 5.5.8.
>> Have you looked at the FEDERATED storage engine?
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc.
> Office: Blountville, TN