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

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