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=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a prefix
hi, do you want to compile or you can use binaries? Claudio 2010/10/15 ml ml mliebher...@googlemail.com 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.na...@gmail.com -- Claudio
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 claudio.na...@gmail.com wrote: hi, do you want to compile or you can use binaries? Claudio 2010/10/15 ml ml mliebher...@googlemail.com 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.na...@gmail.com -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a 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=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a prefix
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 mliebher...@googlemail.com Hi Claudio, i would like to compile it from source. Mario On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni claudio.na...@gmail.com wrote: hi, do you want to compile or you can use binaries? Claudio 2010/10/15 ml ml mliebher...@googlemail.com 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.na...@gmail.com -- Claudio -- Claudio
Re: multiple mysql installations - Install mysql from source with a prefix
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=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a prefix
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
Re: multiple mysql installations - Install mysql from source with a prefix
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
Re: multiple mysql installations - Install mysql from source with a prefix
you can use mysqld_multi On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni claudio.na...@gmail.comwrote: 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
Re: multiple mysql installations?
Minuk Choi [EMAIL PROTECTED] wrote: I managed to get multiple instances of mysql to install and run(via = mysqld_multi), but only by compiling the source. The system I had was Redhat9 and I used the Mysql RPM, but I couldn't = get that to work, so I opted to download and compile the source. Is this the ONLY way to get multiple instances of mysql to run on one = machine? See that: http://dev.mysql.com/doc/mysql/en/Multiple_servers.html http://dev.mysql.com/doc/mysql/en/mysqld_multi.html Usually following these steps you can safely run many instances of MySQL on a single box. Please however use the MySQL official binary release on Linux. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple mysql installations?
I managed to get multiple instances of mysql to install and run(via mysqld_multi), but only by compiling the source. The system I had was Redhat9 and I used the Mysql RPM, but I couldn't get that to work, so I opted to download and compile the source. Is this the ONLY way to get multiple instances of mysql to run on one machine?