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

[root@DB ~]# mysqldump -uroot -p123  --flush-logs --all-databases >fullbackup_sunday_11_PM.sql
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

 这是因为mysqldump默认是不备份事件表的,只有加了--events才会,解决办法:加上--events --ignore-table=mysql.events参数;

[root@DB ~]# /usr/local/mysql/bin/mysqldump -uroot -p123  --events --ignore-table=mysql.events --flush-logs --all-databases >fullbackup_sunday_11_PM.sql
原文地址:https://www.cnblogs.com/bass6/p/5594429.html