Hello, I am using automysqlbackup to backup my database. I have it running with a cron job every Sunday. I have configured everything and it seems to be working fine but I've been getting this error:
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
The way I run the command is the following:
automysqlbackup /etc/automysqlbackup/foo.conf
which contains the conf file with paramenter and all the stuff. I was reading and apparently the --ignore-table=mysql.event will fix the issue (or the --events) but I have no idea where to use it on the conf file. I tried using it at the end of the above command, but then it doesn't do anything, does not backup the database. If anybody has a clue or a way to guide me please let me know. Thank you