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.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. > > > > -- 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=arch...@jab.org