List:General Discussion« Previous MessageNext Message »
From:Hank Date:January 4 2011 10:10pm
Subject:Re: Moving data between two servers with SQL
View as plain text  
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?

-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
>

Thread
Moving data between two servers with SQLHank4 Jan
  • Re: Moving data between two servers with SQLMySQL)4 Jan
    • Re: Moving data between two servers with SQLHank4 Jan
    • Re: Moving data between two servers with SQLHank4 Jan
      • Re: Moving data between two servers with SQLHank4 Jan