Nagios Support Forum

XI 2012R2.9 Ent. Edition
RHEL 6.5
Offloaded DB

I am getting the following errors from the backup log
ERRORS_10.17.19.237-658962937.log

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

Does this mean, the event data is not backed up?
Please advice where to add the --events option.

Thanks.

It is not a nagios events table, as all the nagios db names start with "nagios", "nagiosxi", or "nagiosql".
mysql.event is for built-in mysql scheduled events. I presume this "warning" is benign.

abrist wrote:It is not a nagios events table, as all the nagios db names start with "nagios", "nagiosxi", or "nagiosql".
mysql.event is for built-in mysql scheduled events. I presume this "warning" is benign.

Ok. The backup should backup everything and I don't want to see the error log file everyday.

Then you can make the following adjustment... In /root/scripts/automysqlbackup change the following line
change to this will no longer backup the mysql base db, and stop giving you this error....

scottwilkerson wrote:Then you can make the following adjustment... In /root/scripts/automysqlbackup change the following line
change

Code: Select all

DBNAMES="all"

to

Code: Select all

DBNAMES="nagios nagiosql"

this will no longer backup the mysql base db, and stop giving you this error....

It does not give the error anymore but the error file still created with size 0.

That is created by the following line (~395):
You can probably comment out this line to stop the error log from being created.