automysql backup error

This is a common error warning from AutoMySQLBackup: “– Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.”

It is not an actual problem, only a note that the MySQL event table is not backed up. The easiest  is to just back it up too, by adding the option events to /etc/mysql/my.conf:

[mysqldump] events quick quote-names max_allowed_packet      = 16M

[mysqldump]
events
quick
quote-names
max_allowed_packet      = 16M

automysql backup error
Share this