I have an interesting scenario I am trying to find a solution to.

We currently have the current setup.

ProductionDatabase (publisher) is the publication for transnational replication to the following:
  WarehouseDatabase (subscriber)
  NewWarehouseDatabase (subscriber)

My issue is that WarehouseDatabase has had triggers and other SP's added to it.  When I build replication for NewWarehouseDatabase I built it from a backup of ProductionDatabase.  So NewWarehouseDatabase does not have the triggers or SP's that had been added to WarehouseDatabase.

Doing a SQL Compare generated a list that had a lot more things displayed than I really want to manage.

So I thought I can build replication by backing up WarehouseDatabase and restoring to NewWarehouseDatabase and then enabling replication from ProductionDatabase.  Then I thought that will not work as the LSN and other internals that might not sync up for replication to work.

I am wondering if anyone can suggest how I can accomplish this, if you can understand my babbling...

Regards,
GarryB

This is an old question, but it came up in a search while I was trying to jog my memory about the correct option name and so now that I've figured it out I'm adding the details here.
The key part of the question is:

I mean in an included file like /etc/mysql/conf.d/myCustomFile.cnf

You can do this from an included option file using the option skip-log-bin. E.g. you might create /etc/mysql/conf.d/disable_binary_log.cnf with the following contents:
[mysqld]
skip-log-bin

You can add skip- as a prefix to other options to disable them in this way too.
Related Q & A: To clear currently accumulated logs, see this answer.
