List:General Discussion« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:January 4 2011 9:15pm
Subject:Re: Moving data between two servers with SQL
View as plain text  
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