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

mysqldump fails to work on any lower-version of mariadb

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.12
    • N/A
    • Backup
    • None
    • linux 64

    Description

      In my central office, I have the latest version of Mariadb, 10.3, but I want to connect to all production servers and get a backup of all the objects, not data, from a single point. It turns out it's impossible to use mysqldump on any other version, like 10.2 because it uses ad-hoc commands that fail.
      This is a bug. There is a flag called --compatible, and it does not consider the commands sent, only the output when it should also consider the commands sent to the server. We all need a version of mysqldump that can talk any version of mariadb, using the compatible flag.
      Right now I face the task of creating three boxes to get a backup, one for each major version of MySQL. As you probably imagine, once an application is in production with a certain version, it never gets updated.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              philip_38 Philip orleans
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.