Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Suresh Kuna
you can use mysqld_multi On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni wrote: > did you remove /etc/my.cnf? > > 2010/10/15 ml ml > > > Hello, > > > > i installed mysql with: > > ./configure --prefix=/usr/local/myprefix/mysql/ && make && make install > > > > (at the point mysql is not running ye

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Claudio Nanni
did you remove /etc/my.cnf? 2010/10/15 ml ml > 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: > --

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Himanshu Raina
You can pass the following variables as well --defaults-extra-file= --socket= --port= 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) > >

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
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/m

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Claudio Nanni
Hi Mario, MySQL search my.cnf in this order(if I remember well): 1. /etc/my.cnf 2. /basedir/my.cnf 3. /datadir/my.cnf 4. $userhome/my.cnf you have to make sure that you REMOVE ate least /etc/my.cnf from the system try and let me know Claudio 2010/10/15 ml ml > Hi Claudio,

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Himanshu Raina
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 in

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
Hi Claudio, i would like to compile it from source. Mario On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni wrote: > hi, > do you want to compile or you can use binaries? > > Claudio > > 2010/10/15 ml ml >> >> Hello List, >> >> how do i install mysql COMPLETLY in a diffrent directory? >> >> Righ

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Claudio Nanni
hi, do you want to compile or you can use binaries? Claudio 2010/10/15 ml ml > 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

multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
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