you can use mysqld_multi On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni <claudio.na...@gmail.com>wrote:
> did you remove /etc/my.cnf? > > 2010/10/15 ml ml <mliebher...@googlemail.com> > > > 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.ra...@naukri.com> 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.na...@gmail.com > > > > > > > -- > Claudio > -- Thanks Suresh Kuna MySQL DBA