Home / server / Questions / 544237
Accepted
artfulrobot
Asked: 2013-10-08 00:51:01 +0800 CST

How to avoid mysqldump warning "Skipping the data of table mysql.event"

  • 772

After a recent Debian upgrade on my LAMP webserver to Wheezy, mysqldump is throwing a warning:

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

Events seems to be something special. Man page for mysqldump:

   *   --events, -E

       Include Event Scheduler events for the dumped databases in the output.

I have tried adding --skip-events to tell mysqldump that this is explicitly the behaviour I wanted (although I don't know why...) but it still generates the warning.

How can I (a) stop it emitting this warning, or (b) otherwise include this awkward table, if its something I should be keeping.

debian

2 Answers

  1. Best Answer

    This appears to be a feature for which there is a workaround

    mysqldump -uroot -p --events --ignore-table=mysql.event mysql > /tmp/mysql.sql"

    This says dump the event (--events) table and then ignore it.

    • 20

  2. For folks that are using automysqlbackup you will need to do the following:

    1. Modify or Create your ~/.my.cnf and create a mysqldump section by adding the following

      [mysqldump]
events
ignore-table = mysql.events

    Using this solution guarantees that if you upgrade automysqlbackup that your changes won't be erased. Happy backing up!

    • 9