MySQL BUG#11762933: MYSQLDUMP WILL SILENTLY SKIP THE `EVENT` TABLE DATA IF DUMPS MYSQL DATABA

revno: 2661.862.20

committer: Anirudh Mangipudi <anirudh.mangipudi@oracle.com>

branch nick: 5.1

timestamp: Fri 2012-11-09 15:15:16 +0530

message:

  BUG#11762933: MYSQLDUMP WILL SILENTLY SKIP THE `EVENT`

                TABLE DATA IF DUMPS MYSQL DATABA

  Problem: If mysqldump is run without --events (or with --skip-events)

  it will not dump the mysql.event table's data. This behaviour is inconsistent

  with that of --routines option, which does not affect the dumping of

  mysql.proc table. According to the Manual, --events (--skip-events) defines,

  if the Event Scheduler events for the dumped databases should be included

  in the mysqldump output and this has nothing to do with the mysql.event table

  itself.

  Solution: A warning has been added when mysqldump is used without --events

  (or with --skip-events) and a separate patch with the behavioral change

  will be prepared for 5.6/trunk.