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
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.
>>
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
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
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