FreeLists / mylvmbackup / [mylvmbackup] Re: do_innodb_backup clobbers socket file if socket declared in my.cnf and not overridden

[Lenz Grimmer <lenz@xxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Alain,

thanks for your message!

On 04/09/2008 07:32 AM, Alain Hoang wrote:

> I've been using mylvmbackup (great tool, thanks!) in our production 
> environment for backups.  It has been working great without innodb 
> recovery options, however when I tried turning on innodb recovery and it 
> seems there is a snag.
>     If you don't specify --socket=<something new> in the mysqld_safe 
> parameter for mylvmbackup.conf, the spawned mysqld_safe process which is 
> used for innodb recovery will use the socket from my.cnf which 
> overwrites the old socket location. 
> It is easy enough to specify the
> --socket option in the mysqld_safe parameter however I was hoping it 
> might be possible to fix the behavior or at least document this behavior 
> so other people using this tool don't find this the hard way :)

Hmm, good point - I wonder why I haven't noticed that before! I just commited
a patch to fix this (by pointing --socket to /tmp/mylvmbackup.sock) and will
roll it into a new release right away. Good that I have not made a broad
announcement about 0.7 so far :)

I also added a note to the man page about some other quirks that still remain
with this functionality - right now this only works properly if you go with a
default InnoDB configuration that does not use "file per table" or puts the
logs or data into a separate directory...

> Just for note, I'm currently using 0.7 of mylvmbackup on Ubuntu 7.10.

Thanks for using mylvmbackup and the feedback! It's appreciated.

Bye,
        LenZ
- --
- ------------------------------------------------------------------
 Lenz Grimmer <lenz@xxxxxxxxxxx>                             -o)
 [ICQ: 160767607 | Jabber: LenZGr@xxxxxxxxxx]                /\\
 http://www.lenzg.org/                                       V_V
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFH/Si/SVDhKrJykfIRArH0AJ4oH54p7qPk708ENISipRWQ8FuvyACfdgAH
xlUv49ChuDnLLzuF5qUOZcY=
=ffyt
-----END PGP SIGNATURE-----