You can pass the following variables as well
--defaults-extra-file=<path-to-my.cnf>
--socket=<path-to-socket-file>
--port=<port-no>
On Fri, 2010-10-15 at 18:50 +0530, ml ml wrote:
> Hello,
>
> i installed mysql with:
> ./configure --prefix=/usr/local/myprefix/mysql/ && make && make
> install
>
> (at the point mysql is not running yet)
>
> Next i would like to initialize the DB but get the follwoing error:
> ----------------------------------------------------------------------
> #:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql
> --basedir=/usr/local/myprefix/mysql/
> --datadir=/usr/local/myprefix/mysql/data
> Installing MySQL system tables...
> 101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536
> adjusted to 131072
> /usr/local/myprefix/mysql//libexec/mysqld: File
> '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
> 101015 15:13:17 [ERROR] Aborting
>
> 101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld:
> Shutdown complete
>
>
> Installation of system tables failed! Examine the logs in
> /usr/local/myprefix/mysql/data for more information.
>
>
>
> ----
>
> find /usr/local/myprefix/mysql/data/
> /usr/local/myprefix/mysql/data/
> /usr/local/myprefix/mysql/data/mysql
> /usr/local/myprefix/mysql/data/test
>
> ---
>
> And the folder /var/log/mysql/ does not exist. I dont want it to be
> there anyway.
>
>
> Cheers,
> Mario
>
>
>
> On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina
> <himanshu.raina@stripped> wrote:
> > Hi Mario,
> >
> > While installing a new instance you don't exactly need to mention
> > anything except for the --prefix option. While starting the new instance
> > you can provide all config parameters like config file, datadir etc.
> >
> >
> > On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
> >> Hello List,
> >>
> >> how do i install mysql COMPLETLY in a diffrent directory?
> >>
> >> Right now i am using:
> >> ./configure --prefix=/usr/local/mysql-5.1.42
> >> --sysconfdir=/usr/local/mysql-5.1.42/etc
> >>
> >> BUT, mysql still looks for /etc/my.cnf and for
> >> /var/log/mysql/mysql-bin.index ...
> >>
> >> So what configure options do i need if i want to install mysql
> >> seperatly in a folder?
> >> Do i also need --datadir? If yes, where sould my data dir be? In
> >> /usr/local/mysql-5.1.42/var?
> >>
> >> Thanks a lot,
> >> Mario
> >>
> > --
> > Regards,
> >
> > Himanshu Raina
> > --
> > Guillotine, n.:
> > A French chopping center.
> >
> >
--
Regards,
Himanshu Raina
--
I'm successful because I'm lucky. The harder I work, the luckier I get.
