Suppress the “skipping the data of table mysql.event” message

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.