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

mysqldump to support --skip-definer

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      5.7 compatibility issue and intresting feature
      mysqlpump --skip-definer -h localhost -u user -p yourdatabase

      Attachments

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11000 Compatibility issues between 10.2 and MySQL 5.7

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Rai Rai An added a comment -

            mysqldump needs a parameter --skip-definer

            Rai Rai An added a comment - mysqldump needs a parameter --skip-definer
            irwanto8202 Irwanto Irwanto added a comment -

            i didn't find mysqlpump too in 10.0 and later

            irwanto8202 Irwanto Irwanto added a comment - i didn't find mysqlpump too in 10.0 and later
            jgwinner John Gwinner added a comment -

            This is a killer for us - none of our production databases can be restored without hand-editing the resulting .sql dumped file.

            It's odd as tables that are created by the same user aren't marked with a definer, yet all views seem to be.

            This is a production issue. We can't apply patches until the patch is verified on a copy of production, and our CI/CD routines can't restore the production database to test the patch. Bad situation.

            I tried mysqlpump but got an error "Server version is not compatible. Server version should be 5.6.46 or above." We are on Mariadb 10.6.8.

            jgwinner John Gwinner added a comment - This is a killer for us - none of our production databases can be restored without hand-editing the resulting .sql dumped file. It's odd as tables that are created by the same user aren't marked with a definer, yet all views seem to be. This is a production issue. We can't apply patches until the patch is verified on a copy of production, and our CI/CD routines can't restore the production database to test the patch. Bad situation. I tried mysqlpump but got an error "Server version is not compatible. Server version should be 5.6.46 or above." We are on Mariadb 10.6.8.

            People

              Unassigned Unassigned
              stephane@skysql.com VAROQUI Stephane
              Votes:
              6 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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