Since MySQL v.5.5.29 the
mysqldump command can generate the following error:
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
An example of mysqldump for full dumps is this:
mysqldump --opt -u <USERNAME> -p<PASSWORD> --all-databases | gzip > full_dump.sql.gz
In a case of a server which executes it during periodical backups, this means a warning email from Cron Daemon, very annoying.
If you add, as suggested, the
--events option you can receive this error:
mysqldump: Couldn't execute 'show events': Access denied for user '<USERNAME>'@'localhost' to database '<DATABASE>' (1044)
The solution is to grant the
EVENT permission to the user:
GRANT EVENT ON <DATABASE>.* to '<USERNAME>'@'localhost' with grant option;
Apparently if you don't care about events there's no way to suppress the error message with some
--no-events option, as far as I know.
There's an interesting discussion about this (maybe-not-a-)bug here