[Bug 1219568] Re: automysqlbackup throws warning "skiping the data of table mysql.event"
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 # /etc/automysqlbackup.cnf !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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning "skiping the data of table mysql.event" To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1219568] Re: automysqlbackup throws warning skiping the data of table mysql.event
You might want to try my PPA archive where I upgraded automysqlbackup to v3.0_rc6 (newest upstream): https://launchpad.net/~dasp/+archive/automysqlbackup -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning skiping the data of table mysql.event To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1219568] Re: automysqlbackup throws warning skiping the data of table mysql.event
** Also affects: automysqlbackup (Debian) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning skiping the data of table mysql.event To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1219568] Re: automysqlbackup throws warning skiping the data of table mysql.event
the above work around (changing debian.cnf) only works if you are not specifying a username and password in the config file if [ -z ${USERNAME} -o -z ${PASSWORD} ] ; then mysqldump --defaults-file=/etc/mysql/debian.cnf $NEWOPT $1 $2 else -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning skiping the data of table mysql.event To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1219568] Re: automysqlbackup throws warning skiping the data of table mysql.event
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: automysqlbackup (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning skiping the data of table mysql.event To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1219568] Re: automysqlbackup throws warning skiping the data of table mysql.event
Another possible work around is to add a block to the end of the cnf file automysqlbackup defaults to. File: /etc/mysql/debian.cnf [mysqldump] ignore-table= mysql.event -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1219568 Title: automysqlbackup throws warning skiping the data of table mysql.event To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/1219568/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs