Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6049

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: