Re: Is it possible to run innobackupex without supplying password on the command line?

[Gergo Erdosi]

Hi,

Looking at the code, there are two options:

if ($option_defaults_file) {
$options = $options . " --defaults-file=\"$option_defaults_file\" ";
} else {
$options = $options . "
--defaults-file=\"${backup_dir}/backup-my.cnf\" ";
}

You either need to use the --defaults-file option and point it to your
my.cnf file, or add backup-my.cnf to the backup directory (this file
is loaded if --defaults-file is not specified).

Gergo Erdosi


On Thu, Sep 13, 2012 at 10:42 PM, Chux <chuxu...@gmail.com> wrote:
>
> Hi,
>
> I have a .my.cnf that allows me run mysqladmin and mysql without password ..
> but innobackupex totally ignores it, and seems to insist I must supply my
> password on the command line ..
>
> Is there anyway I can make it use what is in my .my.cnf ?
>
> thanks in advance for any suggestions ..
>
> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/percona-discussion/-/Fogcul-eZxMJ.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discuss...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/percona-discussion?hl=en.

[John Fanjoy]

Does your .my.cnf use [mysql] or [clients]. I think you need a section for clients in order for innobackupex to honor it