MySQL Backup Failing after MySQL Update [#26795]

Submitted by pacolvin on Fri, 04/26/2013 - 07:47 Pro Licensee

I updated the MySQL a few days ago to the latest version through the auto updates. Since then, my daily backup throws this error:

Backing up mysql to /media/backupusb/mysql/mysql.sql .. .. backup failed : -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

The rest of the databases update fine. I'm just having problems with this database. I could not find any option that would allow me to "Specify the --events option" as indicated in the error.

Below is the log from the update.

Any thoughts?

Thanks

Phil

Now updating mysql-server ..

Installing package(s) with command apt-get -y install mysql-server ..

Reading package lists...
Building dependency tree...
Reading state information...
The following packages will be upgraded:
  mysql-server
1 upgraded, 0 newly installed, 0 to remove and 6 not upgraded.
Need to get 71.4kB of archives.
After this operation, 4096B of additional disk space will be used.
Get:1 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-server 5.1.69-0ubuntu0.10.04.1 [71.4kB]
Fetched 71.4kB in 0s (252kB/s)
(Reading database ... 128322 files and directories currently installed.)
Preparing to replace mysql-server 5.1.67-0ubuntu0.10.04.1 (using .../mysql-server_5.1.69-0ubuntu0.10.04.1_all.deb) ...
Unpacking replacement mysql-server ...
Setting up mysql-server (5.1.69-0ubuntu0.10.04.1) ...

.. install complete.

Now updating mysql-server-5.1 ..

Installing package(s) with command apt-get -y install mysql-server-5.1 ..

Reading package lists...
Building dependency tree...
Reading state information...
The following extra packages will be installed:
  libmysqlclient16 mysql-client-5.1 mysql-client-core-5.1 mysql-common
  mysql-server-core-5.1
Suggested packages:
  tinyca mailx
The following packages will be upgraded:
  libmysqlclient16 mysql-client-5.1 mysql-client-core-5.1 mysql-common
  mysql-server-5.1 mysql-server-core-5.1
6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 22.1MB of archives.
After this operation, 283kB of additional disk space will be used.
Get:1 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-common 5.1.69-0ubuntu0.10.04.1 [75.8kB]
Get:2 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main libmysqlclient16 5.1.69-0ubuntu0.10.04.1 [1905kB]
Get:3 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-client-core-5.1 5.1.69-0ubuntu0.10.04.1 [159kB]
Get:4 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-client-5.1 5.1.69-0ubuntu0.10.04.1 [8190kB]
Get:5 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-server-core-5.1 5.1.69-0ubuntu0.10.04.1 [4749kB]
Get:6 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-server-5.1 5.1.69-0ubuntu0.10.04.1 [7048kB]
Preconfiguring packages ...
Fetched 22.1MB in 34s (642kB/s)
(Reading database ... 128322 files and directories currently installed.)
Preparing to replace mysql-common 5.1.67-0ubuntu0.10.04.1 (using .../mysql-common_5.1.69-0ubuntu0.10.04.1_all.deb) ...
Unpacking replacement mysql-common ...
Preparing to replace libmysqlclient16 5.1.67-0ubuntu0.10.04.1 (using .../libmysqlclient16_5.1.69-0ubuntu0.10.04.1_i386.deb) ...
Unpacking replacement libmysqlclient16 ...
Preparing to replace mysql-client-core-5.1 5.1.67-0ubuntu0.10.04.1 (using .../mysql-client-core-5.1_5.1.69-0ubuntu0.10.04.1_i386.deb) ...
Unpacking replacement mysql-client-core-5.1 ...
Preparing to replace mysql-client-5.1 5.1.67-0ubuntu0.10.04.1 (using .../mysql-client-5.1_5.1.69-0ubuntu0.10.04.1_i386.deb) ...
Unpacking replacement mysql-client-5.1 ...
Preparing to replace mysql-server-core-5.1 5.1.67-0ubuntu0.10.04.1 (using .../mysql-server-core-5.1_5.1.69-0ubuntu0.10.04.1_i386.deb) ...
Unpacking replacement mysql-server-core-5.1 ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.69-0ubuntu0.10.04.1) ...
(Reading database ... 128322 files and directories currently installed.)
Preparing to replace mysql-server-5.1 5.1.67-0ubuntu0.10.04.1 (using .../mysql-server-5.1_5.1.69-0ubuntu0.10.04.1_i386.deb) ...
mysql stop/waiting
Unpacking replacement mysql-server-5.1 ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
ureadahead will be reprofiled on next reboot
Setting up libmysqlclient16 (5.1.69-0ubuntu0.10.04.1) ...

Setting up mysql-client-core-5.1 (5.1.69-0ubuntu0.10.04.1) ...
Setting up mysql-client-5.1 (5.1.69-0ubuntu0.10.04.1) ...
Setting up mysql-server-core-5.1 (5.1.69-0ubuntu0.10.04.1) ...
Setting up mysql-server-5.1 (5.1.69-0ubuntu0.10.04.1) ...
mysql start/running, process 32071

Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

.. install complete.

Status:

Active

Comments

Submitted by andreychek on Fri, 04/26/2013 - 08:04 Comment #1

Jamie, this problem sounds like a change in mysqldump behavior.

The mysqldump notice doesn't imply a failure, but was added because MySQL users were confused with mysqldump not dumping the mysql.event table by default.

What would you think about adding the --events switch to mysqldump for MySQL versions 5.1.8 and after (5.1.8 is when MySQL first supported events)?

That will cause it to backup the events table, and then I believe that message would go away.

There's a MySQL bug report on that issue here:

http://bugs.mysql.com/bug.php?id=68376

Submitted by JamieCameron on Fri, 04/26/2013 - 15:25 Comment #2

That's a good idea - in the next Webmin release I will have it add that --events flag.

Submitted by Issues on Fri, 05/10/2013 - 22:21 Comment #3

Automatically closed -- issue fixed for 2 weeks with no activity.

Submitted by tpnsolutions on Sun, 05/12/2013 - 21:30 Comment #4

Jamie,

This issue still persists...

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

I keep getting this message in my backup reports causing all backup emails at first glance to appear like they failed...

Any news on addressing this matter?

-Peter

Submitted by tpnsolutions on Sun, 05/12/2013 - 21:31 Comment #5