From: Hank
Date: January 4 2011 8:53pm
Subject: Moving data between two servers with SQL
List-Archive: http://lists.mysql.com/mysql/223971
Message-Id: <AANLkTikcbK3=ot9HRk7Poas4AEnk=TA8nfU3-yY-AGEo@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=90e6ba6e843eb5616f04990b7744

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

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

--90e6ba6e843eb5616f04990b7744--