How to prevent mysqldump warning “Skipping the data of table mysql.event”

If you found this post helpful, kindly share it and show your support :)

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.


Mohammed Noufal

I'm Mohammed Noufal, working as Server Admin for the last 10 years.  In my day-to-day life, l had to face different problems related to Web-hosting. On my website, you can find solutions for different Web-hosting-related problems. Sometimes, I spent hours searching/googling to find a solution. This inspired me to start a website that gives solutions to different Webhosting problems. This website includes basic Linux and windows commands, and different control panels like cPanel, Plesk, DirectAdmin, Webmin & so on. You can find solutions and or suggestions for different Web-hosting related problems from here. Hence I would like to say Errorlogz is your server protector.  I will be glad if Logdetect can help any one of the Server admins to find a solution to his problem.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *