automysqlbackup throws warning "skiping the data of table mysql.event"

Bug #1219568 reported by James on 2013-09-01
36
This bug affects 6 people
Affects Status Importance Assigned to Milestone
automysqlbackup (Debian)
New
Undecided
Unassigned
automysqlbackup (Ubuntu)
Undecided
Unassigned

Bug Description

I get the following error with automysqlbackup:

"-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly."

in an email sent to me. I installed from apt-get (after a full purge).

Description: Ubuntu 13.04
Release: 13.04

automysqlbackup:
  Installed: 2.6+debian.2-2
  Candidate: 2.6+debian.2-2
  Version table:
 *** 2.6+debian.2-2 0
        500 http://us.archive.ubuntu.com/ubuntu/ raring/universe amd64 Packages
        100 /var/lib/dpkg/status

Expected: no ERRORS REPORTED email
Happened: got errors

A possible workaround:

add "--ignore-table=mysql.event" to the mysqldump command in the script

Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in automysqlbackup (Ubuntu):
status: New → Confirmed
Adrian Walters (adrianwalters) wrote :

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

plod (me-plod) wrote :

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 "

Daniel Speichert (dasp) wrote :

You might want to try my PPA archive where I upgraded automysqlbackup to v3.0_rc6 (newest upstream): https://launchpad.net/~dasp/+archive/automysqlbackup

Rabin (7-rabin) wrote :

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers