-- 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

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

标签：