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

標籤：

 

[[email protected] ~]# 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參數；

[[email protected] ~]# /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.