MySQL Bugs: #69910: mysqlbackup doestnot support --login-path option

Bug #69910	mysqlbackup doestnot support --login-path option
Submitted:	2 Aug 2013 17:20	Modified:	30 Apr 2015 16:22
Reporter:	Srinivasa Krishna Mamillapalli	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Backup	Severity:	S4 (Feature request)
Version:	5.6.10	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	login-path, mysql_config_editor, mysqlbackup

Description:
Looks like there is no compatibility for mysql_config_editor with mysql enterprise backup.

The login accounts created with mysql_config_editor doesnot support for mysqlbackup utility.
There is no option --login-path available for mysqlbackup.

Iam using meb-3.8 and getting the below error when try to use --login-path.

mysqlbackup: unknown variable 'login-path=mysqlbackup'
Noticed that there is no such option supported for mysqlbackup.

This is impacting the usage of encrpted login files across all mysql utilities.
I request to add support for MEB.

Thank you
Krishna.

How to repeat:
NA

Suggested fix:
I request to add --login-path support for MEB.

Hello,

This is not a bug. The mysqlbackup command supports --login-path. See below for example:

=======
shell>  /home/user/MEB/meb-3.9.0-linux2.6-x86-64bit/bin/mysqlbackup --help
MySQL Enterprise Backup version 3.9.0 [2013/08/23] 
Copyright (c) 2003, 2013, Oracle and/or its affiliates. All Rights Reserved.

Usage: 
<snip>
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 
The following groups are read: mysqlbackup client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=#
                        Also read groups with concat(group, suffix)
--login-path=#          Read this path from the login file.
<snip>

shell> mysql_config_editor set --login-path=local --host=localhost --user=dba --password
Enter password: 
WARNING : 'local' path already exists and will be overwritten. 
 Continue? (Press y|Y for Yes, any other key for No) : y

shell> mysql_config_editor print --all
[client]
[local]
user = dba
password = *****
host = localhost

shell> /home/user/MEB/meb-3.9.0-linux2.6-x86-64bit/bin/mysqlbackup --login-path=local --backup-dir=/tmp/MEBTEST/ backup 
MySQL Enterprise Backup version 3.9.0 [2013/08/23] 
Copyright (c) 2003, 2013, Oracle and/or its affiliates. All Rights Reserved.

 mysqlbackup: INFO: Starting with following command line ...
 /home/user/MEB/meb-3.9.0-linux2.6-x86-64bit/bin/mysqlbackup 
        --login-path=local --backup-dir=/tmp/MEBTEST/ backup 

 mysqlbackup: INFO: MySQL server version is '5.6.12-enterprise-commercial-advanced-log'.
 mysqlbackup: INFO: Got some server configuration information from running server.
<snip>
===============

Wow..so, finally after an year, it got added in future versions i.e MEB 3.9. 
Good to see that.

The --login-path option is supported since MEB 3.0.9, which has already been released:
=====
Changes in MySQL Enterprise Backup 3.9.0 (2013-08-28)
...
http://dev.mysql.com/doc/relnotes/mysql-enterprise-backup/3.9/en/news-3-9-0.html
=====

^^^  s/MEB 3.0.9/MEB 3.9.0/