Automysqldump warning


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Automysqldump warning
# 1  
Old 12-12-2013
Automysqldump warning

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

Last edited by bartus11; 12-12-2013 at 04:43 PM.. Reason: Please use code tags
# 2  
Old 12-12-2013
Try CONFIG_table_exclude=( 'mysql.event' ) there should be some doco on this in the default conf file.
This User Gave Thanks to Chubler_XL For This Post:
# 3  
Old 12-17-2013
Thanks, but we discovered we also want to keep the events table instead of ignore it. Apparently everyone opted for ignore it.
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question