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.
-- Irek Slonina
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]