[Automysqlbackup-users] specifying arbitrary mysqldump parameters

[Shawn H. <sou...@el...>]

I've got an Ubuntu 22 server with mysql from the official mysql apt 
repository.

I had automysqlbackup installed from the ubuntu repositories, now I have 
a version from source control.  I can't remember whether it was 
sourceforge or one of the many github forks that I started with.

I have migrated my mysql install to InnoDB Cluster, which makes 
automyslqbackup spit out this warning a bunch of times:

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 looked through the automysqlbackup code for some way in 
automysqlbackup.conf to pass arbitrary parameters to mysqldump, but 
there doesn't appear to be a mechanism for that.

I have added these lines to the end of the parse_configuration function, 
which got rid of the warnings.

     opt=( "${opt[@]}" "--set-gtid-purged=OFF" )
     opt_fullschema=( "${opt_fullschema[@]}" "--set-gtid-purged=OFF" )

I really hate to manually edit the script, though.  If I upgrade it, my 
manual edits are gone.

I looked over the sourceforge project for a little while and couldn't 
see any way to submit a code suggestion or pull request.  Am I just 
blind?  How would I do that?

Thanks,
Shawn