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

MariaDB 10.6.18 seems to generate invalid SQL dumps

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • 10.6.18
    • N/A
    • Backup, Scripts & Clients
    • None
    • Linux

    Description

      https://github.com/MariaDB/server/commit/13663cb5c4

      The SQL dumps generated by MariaDB 10.6.18 (MariaDB dump 10.19) contain:

      /*!999999\- enable the sandbox mode */

      This is a syntax error when importing to other versions of MariaDB or MySQL and therefore it breaks transfers between servers where the server version is not identical. When importing into older versions, you get:

      ERROR at line 7: Unknown command '\-‘.

      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

          Activity

            People

              serg Sergei Golubchik
              adamsmith Adam
              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.