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]



Reply via email to