How to prevent mysqldump warning “Skipping the data of table mysql.event”
If you are taking the MySQL database using mysqldump command, you may receive below warning.
"Warning: Skipping the data of table mysql.event. Specify the –events option explicitly".
You can use –events flag along with mysqldump and run below command to include the events table.
mysqldump -u[DBuser] -p --events DB > DB-bk.sql
FYI :- If you are using the same command & flag on other databases,you will see this output for each database you dump:
-- -- Dumping events for database '[database]' --
So, if the other databases don’t have events and you wish to avoid this output from being displayed, then don’t use the –events flag for those dumps.
If you want to exclude the event table with mysqldump,you will need to run below command
mysqldump -u[DBuser] -p --ignore-table=mysql.event DB > DB-bk.sql
Replace DBuser, DB and DB-bk with your database user, database name and database backup name.