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

mysqldump fails to work on any lower-version of mariadb

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.12
    • Fix Version/s: N/A
    • Component/s: Backup
    • Labels:
      None
    • Environment:
      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

              • Assignee:
                Unassigned
                Reporter:
                philip_38 Philip orleans
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: