Cannot figure out how to specify arbitrary mysqldump options
Automatic MySQL Backup
Brought to you by:
wipe_out
Menu
▾
▴
#56 Cannot figure out how to specify arbitrary mysqldump options
My version is 3.0_rc2. The ticket creation only has v1.0 as a choice.
I am getting this warning from automysqlbackup for each of my databases, because my servers are now running InnoDB Cluster:
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.
I want to pass the indicated --set-gtid-purged=OFFparameter with a config line in automysqlbackup.conf, but I can't figure out how to do it. I've looked over the code and just don't see a way. I would prefer not editing the automysqlbackup script directly.
I was also getting a warning about a need to use --single-transaction. Looking at the automysqlbackup code I was able to figure out the correct config to enable that.
