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.