From: Hank
Date: January 4 2011 10:52pm
Subject: Re: Moving data between two servers with SQL
List-Archive: http://lists.mysql.com/mysql/223978
Message-Id: <AANLkTik5SXR5AxKw1bi+rBFesnR+y_uZiM6kZ8ORfK21@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=90e6ba6e8c762b2a0004990d1fd0

--90e6ba6e8c762b2a0004990d1fd0
Content-Type: text/plain; charset=ISO-8859-1

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 <heskin@stripped> 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.green@stripped> 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
>>
>
>

--90e6ba6e8c762b2a0004990d1fd0--