MySQL - skip a replicated transaction

Sometimes you may run an update on a master node that causes the slave to cry (i.e. a missing table).

To skip a single transaction, run the following:

STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
START SLAVE;

Want to get in touch? mail@adsar.co.uk