[Automysqlbackup-users] specifying arbitrary mysqldump parameters
Automatic MySQL Backup
Brought to you by:
wipe_out
|
From: Shawn H. <sou...@el...> - 2023-06-01 20:35:22
|
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
|