List:General Discussion« Previous MessageNext Message »
From:Himanshu Raina Date:October 15 2010 1:22pm
Subject:Re: multiple mysql installations - Install mysql from source with
a prefix
View as plain text  
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.

Thread
multiple mysql installations - Install mysql from source with a prefixml ml15 Oct
  • Re: multiple mysql installations - Install mysql from source with a prefixClaudio Nanni15 Oct
    • Re: multiple mysql installations - Install mysql from source with a prefixml ml15 Oct
      • Re: multiple mysql installations - Install mysql from source with a prefixClaudio Nanni15 Oct
  • Re: multiple mysql installations - Install mysql from source witha prefixHimanshu Raina15 Oct
    • Re: multiple mysql installations - Install mysql from source with a prefixml ml15 Oct
      • Re: multiple mysql installations - Install mysql from source witha prefixHimanshu Raina15 Oct
      • Re: multiple mysql installations - Install mysql from source with a prefixClaudio Nanni15 Oct
        • Re: multiple mysql installations - Install mysql from source with a prefixSuresh Kuna15 Oct