Bug #56894 innobackupC(mysqlbackup) doesn't work when --socket option is given
Submitted: 21 Sep 2010 13:22 Modified: 28 Sep 2010 20:05
Reporter: Ritheesh Vedire Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Satya B CPU Architecture:Any

[21 Sep 2010 13:22] Ritheesh Vedire 
Description:
innobackupC(mysqlbackup) doesn't connect to the server for --socket option.

How to repeat:
$MYSQLBACKUP --ibbackup=$IBBACKUP --user=root  --socket=/tmp/mysql1.sock my-small.cnf Backup-root/

Where the server(mysqld) is open to connections on /tmp/mysql1.sock.

Suggested fix:
In innobackup.c,  default_mysql_host="127.0.0.1" in which case, TCP/IP is preferred over socket.

If default_mysql_host="localhost" then socket is preferred over TCP/IP.
(See BUG#31577).

There are two ways to solve this (I think so, not sure).

1) use default_mysql_host="localhost". --socket option works fine.
  If port is set, default_mysql_host="127.0.0.1"
2) explore MYSQL_OPT_PROTOCOL option
[28 Sep 2010 12:11] Satya B 
revno: 240
revision-id: satya.bn@sun.com-20100928102524-7do4nnwc68bjpdoc

meb-3.5.next
[28 Sep 2010 20:05] Paul DuBois 
Problem appears in no released version. No changelog entry needed.