— Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.
mysqldump -uroot -pxxxxx –all-databases > all.sql
When exporting a database with mysqldump, MySQL prompts:
“– Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.”
This happens because mysqldump does not back up event tables by default. It only resolves the issue when the –events option is added. Simply include the –events –ignore-table=mysql.events parameters:
mysqldump -uroot -pxxxxx –events –ignore-table=mysql.events –all-databases > all.sql