Warning:skipping The data of table mysql.event. Specify the--events option explicitly

--warning:skipping The data of table mysql.event. Specify the--events option explicitly.

Mysqldump-uroot-pxxxxx--all-databases > All.sql
MySQL prompts "-warning:skipping the data of table mysql.event when exporting the database with mysqldump. Specify the--events option explicitly. "

Because the mysqldump default is not to back up the event table, only the addition of--events will resolve the addition of--events--ignore-table=mysql.events parameters:

Mysqldump-uroot-pxxxxx--events--ignore-table=mysql.events--all-databases > All.sql

Reference URL

Http://bugs.mysql.com

Warning:skipping The data of table mysql.event. Specify the--events option explicitly