On Wed, Sep 29, 2004 at 07:09:37PM +0100, Richard Jones wrote:
> Ideally, i would create another schema (eg called 'replicated_data') on 
> the second machine, into which i'd replicate bits and pieces from the 
> first database. Is this possible, or do i have to replicate the full 
> table?

I don't think it's possible to do exactly what you want.

However, you could create another table on the master with just the fields
you need, maintain it with triggers on the main table, and then replicate 
just the new table.

-- 
When we vote for taxes, we are voting to steal from our neighbors