Populate a table on a selective replication slave We have a setup with a data mining slave with a lot of replicate-ignore-table= for tables that aren't needed. Now the developers have requested to populate a table that is currently ignored. How do I go about populating it so that the replication can be started again at the correct point.

I want to avoid locking the table on the master instance as that would lead to application downtime.

We are not yet using GTID.

I have access to MySQL Enterprise Backup if that helps.
Do these two steps while nothing is being added to the table:


Manually copy the table to the Slave(s) (even if empty -- need table definition).
Remove the replacate-ignore setting.