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

mysqldump uses 10.3 options with pre-10.3 servers and breaks

    Details

      Description

      When issuing a 10.3 mysqldump command to dump triggers and routines from a 10.2 server, the tool breaks because it tries to issue a SHOW PACKAGES command which is not supported in 10.2 and earlier releases.

      mysqldump --quick --routines --triggers --no-create-info --skip-lock-tables --no-data --compress -h 10.10.16.138 -u mariadb_mock_import -p myschema

      ....

      mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'myschema'': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PACKAGE STATUS WHERE Db = 'myschema'' at line 1 (1064)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                anel Anel Husakovic
                Reporter:
                rpizzi Rick Pizzi
              • Votes:
                5 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: