[prev in list] [next in list] [prev in thread] [next in thread] 

List:       linux-ha
Subject:    Re: [Linux-HA] Odd MySQL Issue
From:       "Eddie C" <edlinuxguru () gmail ! com>
Date:       2006-10-31 7:43:36
Message-ID: cbbf4b570610302343k68622ab5hf9346cc2797f221a () mail ! gmail ! com
[Download RAW message or body]

Two shots in the dark.
 A my.cnf in a home folder could override the one in /etc.

You can specify this command line. to mysqld
mysqld --database=/path/to/dir

The command line directive will override compiled-in and my.cnf directives.
That is a bit of a hack but if you are after results that might be your alswer.

Edward



On 10/30/06, Tony's Linux <linux@oaktechnologies.com.au> wrote:
>
> hi,
>
> did everything, as in HA + DRBD + mysql worked before u shifted the
> working
> directory ?
> what version of DRBD, HA and mysql are u using ?
>
> On Tuesday 31 October 2006 13:21, CA Lists wrote:
> > I have an odd issue where MySQL will not start when heartbeat tries to
> > start it (via LSB script) ONLY when I change the datadir in the
> > /etc/my.cnf. If I execute the script manually, it starts just fine. If I
> > comment out the datadir variable, heartbeat is able to start it just
> fine.
> > Where I am trying to move mysql data to is a DRBD disk (/data/db/mysql).
> I
> > checked
> > permissions, made sure the filesystem is mounted before MySQL starts. I
> > checked the mysql logs, which just say "mysql started" next line "mysql
> > ended". In the ha-debug log, I just get:
> >
> > Starting MySQL...................[FAILED]
> >
> > No additional info. Anyone have any thoughts on why this works manually,
> > but not when heartbeat tries to start it? I tried setting basedir also,
> but
> > no luck there. Thanks,
> >
> > Rob
> >
> >
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA@lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> Linux-HA@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>
_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
[prev in list] [next in list] [prev in thread] [next in thread]