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

Sandbox mode \- is not compatible with --binary-mode

Details

    Description

      Latest MariaDB prepends sandbox mode enable command in the dumps:

      $ mysqldump database_name | head -n 1
      		 
      /*!999999\- enable the sandbox mode */

      Dump with this prefix can not be restored when `--binary-mode` flag is used:

      $ mysqldump database_name | mysql --binary-mode another_db
      		 
      ERROR at line 1: Unknown command '\-'.

      Is there a way to opt-out of sandbox mode when creating a dump?

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33727 mariadb-dump trusts the server and does not validate the data

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34395 Binary mode import breaks with /*!999999\- enable the sandbox mode */

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            fln Julius created issue -
            fln Julius made changes -
            Field Original Value New Value
            fln Julius made changes -
            Description Latest MariaDB prepends sandbox mode enable command in the dumps:

            ```
            $ mysqldump database_name | head -n 1
            /*!999999\- enable the sandbox mode */
            ```

            Dump with this prefix can not be restored when `--binary-mode` flag is used:

            ```
            $ mysqldump database_name | mysql --binary-mode another_db
            ERROR at line 1: Unknown command '\-'.
            ```

            Is there a way to opt-out of sandbox mode when creating a dump?             		Latest MariaDB prepends sandbox mode enable command in the dumps:

            {noformat}
            $ mysqldump database_name | head -n 1
            /*!999999\- enable the sandbox mode */
            {noformat}

            Dump with this prefix can not be restored when `--binary-mode` flag is used:

            {noformat}
            $ mysqldump database_name | mysql --binary-mode another_db
            ERROR at line 1: Unknown command '\-'.
            {noformat}

            Is there a way to opt-out of sandbox mode when creating a dump?
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik made changes -
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            sanja Oleksandr Byelkin made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexander Barkov [ bar ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            bar Alexander Barkov made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ] Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.5.26 [ 29832 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.19 [ 29833 ]
            Fix Version/s 10.11.9 [ 29834 ]
            Fix Version/s 11.1.6 [ 29835 ]
            Fix Version/s 11.2.5 [ 29836 ]
            Fix Version/s 11.4.3 [ 29837 ]
            serg Sergei Golubchik made changes -

            People

              sanja Oleksandr Byelkin
              fln Julius
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.