Re: Moving data between two servers with SQL

2011-01-04 Thread Hank
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 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

Re: Moving data between two servers with SQL

2011-01-04 Thread Hank
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.gr...@oracle.com> wrote: > On 1/4/2011 15:53, Hank wrote: > >> Hello, >> >>I have a background process that runs as a combination of PHP&MySQL. >>

Re: Moving data between two servers with SQL

2011-01-04 Thread Hank
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) < s

Re: Moving data between two servers with SQL

2011-01-04 Thread Shawn Green (MySQL)
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

Moving data between two servers with SQL

2011-01-04 Thread Hank
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