Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1923

LP #1013432: mysqldump gives malformed CHANGE MASTER query when using --include-master-host-port

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Mike Siekkinen last update 12-09-2016 13:11:46

      Using mysqldump Ver 10.13 Distrib 5.5.24, for Linux (x86_64) from Percona server 5.5.24 doing mysqldumps with --dump-slave --master-data=1 --include-master-host-port options output a malformed CHANGE MASTER query.

      It comes out looking like

      CHANGE MASTER TO MASTER_HOST='master-server', MASTER_PORT='3325', MASTER_LOG_FILE='master-server-bin.000741', MASTER_LOG_POS=337983289;

      The problem is the value for MASTER_PORT is in quotes. mysql chokes on this as it requires an unquoted integer value.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist