-- Warning: Skipping the data of table mysql.event

全量导出时出现-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

[root@light4 tools]# sh mysqlbak.sh
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
sending incremental file list
./
192.168.15.244/
192.168.15.244/mysql_2016-10-15.tar.gz
     8797112 100%  203.97kB/s    0:00:41 (xfer#1, to-check=1/5)
192.168.15.244/smartlight_2016-10-15.tar.gz
   163929239 100%  209.31kB/s    0:12:44 (xfer#2, to-check=0/5)

这是因为mysqldump默认是不备份事件表的,只有加了--events 才会，解决办法：

加上--events --ignore-table=mysql.events参数即可；