xtrabackup doesn't finds the config file in debian

[Alex Barrera]

I had to compile xtrabackup for 32 bits and I did so against MySQL 5.0.77 source. The problem? xtrabackup uses my_print_default_files() (libmysql/default.c) to look for config files. By default, the MySQL source looks for the config file in:

Default options are read from the following files in the given order:
/etc/my.cnf /usr/local/etc/my.cnf ~/.my.cnf

Problem is that the deb mysql package puts the config file under /etc/mysql/my.cnf. So I guess that the tool should either do an extra check for that path or (more logically) add a cmd line flag to specify a config file (-c config_path).

Hope this helps :)

Alex

[Yasufumi Kinoshita (yasufumi-kinoshita)]

You can change the path in the

mysys/default.c

line

  errors += add_directory(alloc, "/etc/", dirs);

to your favorite directories.

We assume xtrabackup is build with the same source of the MySQL used.

[Vadim Tkachenko (vadim-tk)]

Yasufumi,

But can't we make xtrabackup to accept --defaults-file=/etc/my.special.cnf
like all standard mysql utilities do ?

Yasufumi Kinoshita wrote:
> You can change the path in the
>
> mysys/default.c
>
> line
>
> errors += add_directory(alloc, "/etc/", dirs);
>
> to your favorite directories.
>
> We assume xtrabackup is build with the same source of the MySQL used.
>
> ** Changed in: percona-xtrabackup
> Importance: Undecided => Low
> Status: New => Won't Fix
>

--
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone [phone]
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/

  Attend the 2009 Percona Performance Conference
  April 22-23 - http://conferences.percona.com/

[Alex Barrera (abarrera-inkzee)]

Yeah I know I can edit that line, but the problem is that if you distribute binaries of the tool not everyone will be happy with my choices ;)

I think what Vadim suggests is a much flexible solution :)

Alex

[Peter Zaitsev (pz-percona)]

Vadim,

Yeah this is right way to do it.

xtrabackup should have same look and feel as other MySQL utilities -
command line options are same as config file lines; config file can
be specified.

Tuesday, March 24, 2009, 12:14:11 AM, you wrote:

> Yasufumi,

> But can't we make xtrabackup to accept
> --defaults-file=/etc/my.special.cnf
> like all standard mysql utilities do ?

--
Peter Zaitsev, CEO, Percona Inc.
Tel: [phone] ext 501 Skype: peter_zaitsev
24/7 Emergency Line [phone] ext 911
Attend the 2009 Percona Performance Conf
Apr 22-23 http://conferences.percona.com/

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Peter, Vadim,

xtrabackup has same look and feel as other MySQL utilities already.
It uses libmysys.a.

Of course, xtrabackup accept --defaults-file=# option now...

[Peter Zaitsev (pz-percona)]

Yasufumi,

OK thanks :)

Tuesday, March 24, 2009, 5:10:12 PM, you wrote:

> Peter, Vadim,

> xtrabackup has same look and feel as other MySQL utilities already.
> It uses libmysys.a.

> Of course, xtrabackup accept --defaults-file=# option now...

--
Peter Zaitsev, CEO, Percona Inc.
Tel: [phone] ext 501 Skype: peter_zaitsev
24/7 Emergency Line [phone] ext 911
Attend the 2009 Percona Performance Conf
Apr 22-23 http://conferences.percona.com/

[Vadim Tkachenko (vadim-tk)]

Yasufumi,

but innobackupex does not understand --defaults-file

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Vadim,

Aha. But I have already fixed innobackupex.

http://bazaar.launchpad.net/~percona-dev/percona-xtrabackup/trunk/revision/36

[Shahriyar Rzayev (rzayev-sehriyar)]

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