R: R: R: Multiple instances howto

2008-04-01 Thread Nanni Claudio
] Inviato: martedì 1 aprile 2008 2.10 A: mysql@lists.mysql.com Oggetto: Re: R: R: Multiple instances howto Nanni, To make things even creepier, I tried to access the 2 "alleged" instances from a different WinXP PC by starting 2 instances of MySQL Administrator, using different port number

Re: R: R: Multiple instances howto

2008-03-31 Thread toutiao
mysql user (e.g.: mysql5018) >> >> 5) install mysql (follow the manual) as that user >> >> 6) create the .my.cnf file and put it in the home directory of the user >> (/home/mysql5018/.my.cnf) >> >> IMPORTANT: watch for right permissions on files and directo

Re: R: R: Multiple instances howto

2008-03-31 Thread toutiao
gt; command line parameters at all, given you are logged as the right mysql > user(mysql5018) and the .my.cnf is in his home directory. > > This is how I got so far. > > Aloha! > > Claudio Nanni > > > > -Messaggio originale- > Da: toutiao [mailto:[EMAIL PR

R: R: Multiple instances howto

2008-03-31 Thread Nanni Claudio
Da: toutiao [mailto:[EMAIL PROTECTED] Inviato: sabato 29 marzo 2008 22.05 A: mysql@lists.mysql.com Oggetto: Re: R: Multiple instances howto Nanni, Thanks for the advices. How to make an installation? I use Fedora Core 8 where MySQL comes with the bundle. Do you think I should download the so

Re: R: Multiple instances howto

2008-03-29 Thread toutiao
Nanni, Thanks for the advices. How to make an installation? I use Fedora Core 8 where MySQL comes with the bundle. Do you think I should download the source code and compile it and configure it using ./configure? I did changed the cnf file to have 2 different configurations: [EMAIL PROTECTED] m

R: Multiple instances howto

2008-03-28 Thread Nanni Claudio
Hi Jing, Logically speaking, you can run as many instances of mysql as you want, but you have to make an installation for each mysql instance. On each instance you can have as many databases as you want. From my experience here is the key: 1) One different mysql user (mysql41,mysql50) for each my