Chris Knipe wrote:
> Sure, there is a syntax error in the query - yes. But why does the
> master not put the complete query in the bin log????????? This is the
> second time in 3 days that it has happened now. Whilst we are on this,
> how do I tell the slave to skip the query and proceed with the rest of
> the binlog... Thanks to this now, we already have a MASSIVE backlog that
> needs to be processed.
I do not know if it is a best solution but that's shure that it's an
easiest. Just add
slave-skip-errors = all
to the config... or just with errors that you want to skip, refer to the
manual for an extensive description.