#79 Use --events

open
nobody
None
5
2015-08-18
2013-05-20
No

MySQL 5.5.30 introduced a compatibility warning that means an "error" is detected on every run. Refer: http://datacharmer.blogspot.com.au/2013/02/mysql-and-warnings-yet-another.html

The output emailed after every run is below. Workaround is to add '--events' to the opt() array at the top of the 'parse_configuration' function.

From: root <root@xxxxxxxxxx.com.au>
To: root@xxxxxxxxxxxxxxxxxx.com.au
Subject: ERRORS REPORTED: MySQL Backup error Log for svr-dbms-01 - 2013-05-20_00h20m
Date: Mon, 20 May 2013 00:20:18 +1000

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

Discussion

  • larsen255

    larsen255 - 2015-08-04

    Or use
    opt=( '--ignore-table=mysql.event' )

     
  • Christian Weiske

    since we want a backup, the event table should probably in the backup.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks