mysqldump gives malformed CHANGE MASTER query when using --include-master-host-port

Bug #1013432 reported by Mike Siekkinen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Low
Stewart Smith
5.5
Fix Released
Low
Stewart Smith

Bug Description

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.

Related branches

Stewart Smith (stewart)
Changed in percona-server:
importance: Undecided → Low
assignee: nobody → Stewart Smith (stewart)
status: New → Fix Committed
tags: added: upstream
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1923

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.