Nevermind -- it's working absolutely perfectly between 5.5.8 and 4.1.x.
Thanks again for the push.
On Tue, Jan 4, 2011 at 5:14 PM, Hank <heskin@stripped> wrote:
> Also, can I do this:
> insert into federated_table select * from local_table?
> On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) <
> shawn.l.green@stripped> wrote:
>> 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
>>> 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