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

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