multiple mysql installations - Install mysql from source with a prefix

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

--20cf300fae03fdfe4e0492a6adc2
Content-Type: text/plain; charset=ISO-8859-1

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 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>


--
Claudio

--20cf300fae03fdfe4e0492a6adc2--

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

Hi Claudio,

i would like to compile it from source.

Mario


On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni wr=
ote:
> 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=3D/usr/local/mysql-5.1.42
>> --sysconfdir=3D/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
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> =A0http://lists.mysql.com/mysql?unsub=3Dclaudio.nanni@gmail. com
>>
>
>
>
> --
> Claudio
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: multiple mysql installations - Install mysql from source witha prefix

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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

--0016e642db8c2eaa110492a6c48f
Content-Type: text/plain; charset=ISO-8859-1

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,
>
> 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?
> >>
> >> 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
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
> >>
> >
> >
> >
> > --
> > Claudio
> >
>



--
Claudio

--0016e642db8c2eaa110492a6c48f--

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

Hello,

i installed mysql with:
../configure --prefix=3D/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=3Dmysql
--basedir=3D/usr/local/myprefix/mysql/
--datadir=3D/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
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=3D/usr/local/mysql-5.1.42
>> --sysconfdir=3D/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.:
> =A0 =A0 =A0 =A0A French chopping center.
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: multiple mysql installations - Install mysql from source witha prefix

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)
>
> 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
> 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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

--0016369f9ff8b882ad0492a8ff91
Content-Type: text/plain; charset=ISO-8859-1

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:
> ------------------------------------------------------------ ----------
> #:/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
> 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.
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>


--
Claudio

--0016369f9ff8b882ad0492a8ff91--

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

--0022159755da9bfded0492a9e6b0
Content-Type: text/plain; charset=ISO-8859-1

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 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
> > 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.
> > >
> > >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
> >
> >
>
>
> --
> Claudio
>



--
Thanks
Suresh Kuna
MySQL DBA

--0022159755da9bfded0492a9e6b0--