Re: parallel installations of mysql

2016-07-05 Thread Jan Steinman
> From: Reindl Harald > > Am 03.07.2016 um 04:47 schrieb Martin Mueller: >> If port 3306 is taken, how is one supposed to know that 3307 is a good >> alternative? Why not 3317 or 3703 > > seriously? > > when this is your point about bad documentation than you just don't have a > point I have

Re: parallel installations of mysql

2016-07-02 Thread Reindl Harald
Am 03.07.2016 um 04:47 schrieb Martin Mueller: If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703 seriously? when this is your point about bad documentation than you just don't have a point - there is no "good alternive". ist's only a q

Re: parallel installations of mysql

2016-07-02 Thread Martin Mueller
Thanks. That’s helpful and makes me think that there may be a “Mac hole” in the MySQL documentation. Windows is one thing and Linux another. OS X is sort of Unix, but only sort of, and the conventions are not as firmly established. For instance, the instructions for the MySQl Sandbox—on the face

Re: parallel installations of mysql

2016-07-02 Thread Reindl Harald
Am 03.07.2016 um 00:49 schrieb Martin Mueller: After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators

Re: parallel installations of mysql

2016-07-02 Thread Hal.sz S.ndor
2016/07/02 18:49 ... Martin Mueller: It’s clear from Section 6.6 of the Reference manual that I need to make sure that the new installation differs from the old one with regard to the data directory, the port number, the socket, the shared memory-base-name, and the pid-file. It’s less clear t

Re: parallel installations of mysql

2016-07-02 Thread Martin Mueller
his? Well, I have a set of databases and tables on > the old installations that have grown over the years. Given the way I work, > the simplest thing would be install the new database and then work through my > existing tables over a number of weeks and transfer stuff as I go along.

Re: parallel installations of mysql

2016-04-21 Thread shawn l.green
have a set of databases and tables on the old installations that have grown over the years. Given the way I work, the simplest thing would be install the new database and then work through my existing tables over a number of weeks and transfer stuff as I go along. That may not be very

Re: parallel installations of mysql

2016-04-21 Thread Johan De Meersman
:-) - Original Message - > From: "Martin Mueller" > To: "MySql" > Sent: Wednesday, 20 April, 2016 20:04:57 > Subject: parallel installations of mysql > I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to > install 5.7.12. Can I install it a

parallel installations of mysql

2016-04-20 Thread Martin Mueller
installations that have grown over the years. Given the way I work, the simplest thing would be install the new database and then work through my existing tables over a number of weeks and transfer stuff as I go along. That may not be very professional but it works for me, and it would let me

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

Re: multiple mysql installations?

2004-10-26 Thread Egor Egorov
"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

multiple mysql installations?

2004-10-22 Thread Minuk Choi
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 instan

Re: path for my.cnf with dual mySQL installations

2004-02-12 Thread Egor Egorov
conflicts with my > other MySQL installation. Does anyone have a tip for where I can staticly set the > path for my.cnf` for one of my MySQL installations? You can use --defaults-file option to specify path to the option file. For example: shell> mysqld_safe --defaults-file=/pat

path for my.cnf with dual mySQL installations

2004-02-12 Thread Jonas Lindén
for where I can staticly set the path for my.cnf` for one of my MySQL installations? Regards /Jonas

RE: Highly Reliable MySQL Installations

2003-02-20 Thread Simon Green
MySQL Installations Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the

Highly Reliable MySQL Installations

2003-02-20 Thread Richard Morton
Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the other server for all DB

Re: Unix binary installations somewhere other than in /usr/local

2002-01-29 Thread John Murdie
On 28 Jan, Paul DuBois wrote: >On 28 Jan John A. Murdie wrote: >>I decided that it was probably simpler just to build from source - I'm >>on a Solaris 2.8 system - and so it proved to be. I was careful to use >>the recommended configure options. >> >>I found that I had to build in the installation

Re: Unix binary installations somewhere other than in /usr/local

2002-01-28 Thread Paul DuBois
At 20:51 + 1/28/02, John Murdie wrote: >On 26 Jan, To: [EMAIL PROTECTED] wrote: >>> I'd like to see an explicit statement that it is possible to install a >> binary distribution of MySQL in some non-standard place, or not, as the >> case might be. If it *is* possible, I'd like to see full i

Re: Unix binary installations somewhere other than in /usr/local

2002-01-28 Thread John Murdie
On 26 Jan, To: [EMAIL PROTECTED] wrote: >> I'd like to see an explicit statement that it is possible to install a > binary distribution of MySQL in some non-standard place, or not, as the > case might be. If it *is* possible, I'd like to see full instructions > for doing this. Thanks to the two p

Re: Unix binary installations somewhere other than in /usr/local

2002-01-26 Thread Jeremy Zawodny
On Sat, Jan 26, 2002 at 07:53:35PM +, John Murdie wrote: > > I'd like to see an explicit statement that it is possible to install > a binary distribution of MySQL in some non-standard place, or not, > as the case might be. If it *is* possible, I'd like to see full > instructions for doing this

Unix binary installations somewhere other than in /usr/local

2002-01-26 Thread John Murdie
I've read the document `Installing a MySQL Binary Distribution' that comes with each Unix binary distribution, and the MySQL manual (http://www.mysql.com/documentation/mysql/full/), and the DynamicFAQ under `Installation' (http://swfaq.mysql.com/sw/bin/17/supportwizard.cgi/07375836), but have foun

Re: installations

2001-10-31 Thread Sinisa Milivojevic
Nathan A. Saint Clair writes: > I'm looking for instructions on installing the mysql GUI interface on a unix system. > Is that possible? Thank you, > > Nathan Of course it is possible. What Unix system. There are binaries for Linux and some other Unix systems ready so that you can download t

installations

2001-10-30 Thread Nathan A. Saint Clair
I'm looking for instructions on installing the mysql GUI interface on a unix system. Is that possible? Thank you, Nathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Multiple installations of MySQL

2001-01-15 Thread Alejandro Arredondo
Hello, We are programming the Control Panel of an Internet Data Center. They are going to install MySQL for each user in ther domain and they will assign a port to each installation of MySQL. If it possible to access the specific intallation of each user in a different port with PHP. How ca