Shell Programming and Scripting

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:

Code:

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

Code:

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

Try CONFIG_table_exclude=( 'mysql.event' ) there should be some doco on this in the default conf file.

Thanks, but we discovered we also want to keep the events table instead of ignore it. Apparently everyone opted for ignore it.