I do apologize if this has been asked before but my search skills were not able to turn up a definitive answer.
SITUATION: I have two Windows Server 2012 R2 servers running WAMP 3.06 (which contains MySQL 5.7.14). They are setup for replication with a master-slave configuration using binary logging. I have a PowerShell script that makes a dump of the database each night. The PowerShell code looks like this...
# Variables . (Join-Path $PSSCriptRoot MySQL_Vars.ps1) # Backup the database cmd /C " `"$mysqlDump`" $mysqlRoutineFlags -u $mysqlUser -p`"$mysqlPass`" $mysqlDB > $mysqlBkp"
QUESTION: How could I do this so that when the MySQL dump occurs, it is not written to the binary logs?
Thank you in advance for your help!