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.
Comments