Backup Errors

[rajasegar]

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.

[abrist]

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.

[rajasegar]

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.

[scottwilkerson]

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....

[rajasegar]

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.

27-06-2014 07-23-29 AM.png

[tmcdonald]

That is created by the following line (~395):

Code: Select all

touch $LOGFILE

You can probably comment out this line to stop the error log from being created.