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

Please implement mysqldump --add-drop-trigger from MySQL 5.6

Details

    Description

      It's been implemented on MySQL 5.6.0:

      See:

      https://bugs.mysql.com/bug.php?id=34325

      Needed for dumping and easier recreating triggers to another 'DEFINER'

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik added a comment -

          Wouldn't it be simpler always to use CREATE OR REPLACE TRIGGER in mysqldump?

          serg Sergei Golubchik added a comment - Wouldn't it be simpler always to use CREATE OR REPLACE TRIGGER in mysqldump?
          elenst Elena Stepanova added a comment -

          If we want to do/fix it in 10.2, it should probably go before GA.
          I don't think using CREATE OR REPLACE in mysqldump is a good idea, it will make it unusable for all MySQL and for MariaDB 5.5.

          elenst Elena Stepanova added a comment - If we want to do/fix it in 10.2, it should probably go before GA. I don't think using CREATE OR REPLACE in mysqldump is a good idea, it will make it unusable for all MySQL and for MariaDB 5.5.
          sanja Oleksandr Byelkin added a comment -

          revision-id: 2761c2e4c1e3fcf95346fcabc6ae23f9e4afc326 (mariadb-10.2.5-129-g2761c2e4c1e)
          parent(s): 52463ccff7ee5024f00541c12938ffbaf9b93958
          committer: Oleksandr Byelkin
          timestamp: 2017-05-03 12:26:57 +0200
          message:

          MDEV-10431: Please implement mysqldump --add-drop-trigger from MySQL 5.6

          pot of mysql changeset by Georgi Kodinov <Georgi.Kodinov@Oracle.com>:

          Bug #34325 : --add-drop-trigger option for mysqldump

          Implemented the --add-drop-trigger option to prepend each
          CREATE TRIGGER in the dump file with DROP TRIGGER.
          The option is off by default. Added a test case.

          —

          sanja Oleksandr Byelkin added a comment - revision-id: 2761c2e4c1e3fcf95346fcabc6ae23f9e4afc326 (mariadb-10.2.5-129-g2761c2e4c1e) parent(s): 52463ccff7ee5024f00541c12938ffbaf9b93958 committer: Oleksandr Byelkin timestamp: 2017-05-03 12:26:57 +0200 message: MDEV-10431 : Please implement mysqldump --add-drop-trigger from MySQL 5.6 pot of mysql changeset by Georgi Kodinov <Georgi.Kodinov@Oracle.com>: Bug #34325 : --add-drop-trigger option for mysqldump Implemented the --add-drop-trigger option to prepend each CREATE TRIGGER in the dump file with DROP TRIGGER. The option is off by default. Added a test case. —

          People

            sanja Oleksandr Byelkin
            Phoenix the II Phoenix the II
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.