Can someone tell me what the correct syntax for this is?
SET SQL_SLAVE_SKIP_COUNTER=n
Skip the next n events from the master. Only valid when the slave thread is not
running, otherwise, gives an error. Useful for recovering from replication glitches.
mysql> show slave status\G
*************************** 1. row ***************************
Master_Host: dbserver.quickbusiness.com
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Log_File: QBSLXDB1-bin.044
Pos: 2753978
Slave_Running: No
Replicate_do_db: qbslive
Replicate_ignore_db:
1 row in set (0.00 sec)
mysql> SET SQL_SLAVE_SKIP_COUNTER=1;
ERROR 1064: You have an error in your SQL syntax near 'SQL_SLAVE_SKIP_COUNTER=1' at
line 1
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
