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.