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