Can someone tell me how to prevent the following commands

 DROP TABLE <tbl-name>;
 TRUNCATE TABLE <tbl-name>;

from being replicated to slaves?

  • Out of curiosity, could you elaborate why you wish to do this? Generally you want your slave to be 1:1 with your master.
    – atxdba
    Oct 15, 2014 at 22:01

1 Answer 1


Disable binary logging in your session, drop the table, and enable binary logging.

SET sql_log_bin = 0;
SET sql_log_bin = 1;

This works because if the Slaves do not see the DROP TABLE command registered in the Master's binary logs, it cannot run the DROP TABLE.

I have recommended using SET sql_log_bin = 0; before in my earlier posts

Give it a Try !!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.