I'm using Ubuntu 14.04 and i'm still affected by this problem, there are 2 why i found one can solve this problem,
1. Change the `automysqlbackup` script and allow for external overwrite of the $OPT variable.
The $OPT variable is defined only on the automysqlbackup script after the call for `/etc/default/automysqlbackup`
and outside the `if` statment in the head which define all the defaults.
This why we can set the OPT variable in the default file to include the option `--ignore-table=mysql.events`
2. let automysqlbackup to use its own `--defaults-file` which include the call for /etc/mysql/debian.cnf and includedir /etc/mysql/conf.d/ (where i put all my overwrites)
I'm using Ubuntu 14.04 and i'm still affected by this problem, there are 2 why i found one can solve this problem,
1. Change the `automysqlbackup` script and allow for external overwrite of the $OPT variable.
The $OPT variable is defined only on the automysqlbackup script after the call for `/etc/default/ automysqlbackup `
and outside the `if` statment in the head which define all the defaults.
one can change the line in the script to be ,
OPT+=" --quote-names"
-or-
OPT="${OPT} --quote-names"
This why we can set the OPT variable in the default file to include the option `--ignore- table=mysql. events`
2. let automysqlbackup to use its own `--defaults-file` which include the call for /etc/mysql/ debian. cnf and includedir /etc/mysql/conf.d/ (where i put all my overwrites)
e.g ackup.cnf
####
# /etc/automysqlb
!include /etc/mysql/ debian. cnf
!includedir /etc/mysql/conf.d/
####
and then one can put a file under /etc/mysql/conf.d/
just to overwrite mysqldump with
File: /etc/mysql/ conf.d/ mysqldump. cnf
[mysqldump]
ignore-table = mysql.event