Suppress the "skipping the data of table mysql.event" message

Posted in MySql -

When using the mysqldump command to make a back of the mysql database, you might get the message "Warning: Skipping the data of table mysql.event. Specify the --events option explicitly". This post shows how to suppress this message.

How to suppress the message

How to suppress it is given in the message: simply add --events to the command. If you were doing this, for example:

mysqldump -u root -p mysql > mysql.sql

simply add --events like this:

mysqldump --events -u root -p mysql > mysql.sql

Easy! This is useful if you are doing automated backups and do want to see error messages, but not this particular one every time a backup is done.

Other databases

Note that when using the same command & flag on other databases, you'll see this output for each database you dump:

-- Dumping events for database '[database]'

So if the other databases do not have events, and you want to prevent this output from being displayed, then don't use the --events flag for those dumps.

Related posts: