Hi Okan, Well, the only solution I know of, to diffrentiate the two servers are to provide different argument on the command line. The server will allways read any of the files; my.ini or my.cnf first, and there set the parameters, after that it will take the command line arguments. This means that you should make sure that you override any properties in the files with the command line args, if necessary.
There are couple of pages of this information in the manul; "Running Multiple MySQL Server on the same Machine." Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -----Original Message----- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: 01 September 2002 11:40 To: Tobias Eriksson Subject: Re: How to run multiple mysql servers Hi Tobias, I am planning to run two servers at the same machine which are also replicating each other. But I want these servers to have different variables/my.ini files. I just wonder about the initial parameters of the second MySQL server. Does it also read the c:/winnt/my.ini values or do you refer it to some other parameter file? If so, how? Thanks for your help Regards Okan ----- Original Message ----- From: "Tobias Eriksson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 30, 2002 3:47 PM Subject: RE: How to run multiple mysql servers I got it! Sorry, ohh... So simple The reason for the problem was ofcourse that I did not provide a --datadir=c:\\mysql\\data parameter, this superseeded the parameter set in the config file. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -----Original Message----- From: Tobias Eriksson Sent: 30 August 2002 14:41 To: [EMAIL PROTECTED] Subject: How to run multiple mysql servers I would like to run >2 mysqld-nt at the same time. This is because we are shipping mysql with our product and then we would like to have the database installed within our product. And also run separate from any other MySQL database that might be installed on the system. When I try to run the command: C:\mysql\bin>mysqld-nt --basedir=c:\\mysql --port=3321 --standalone mysqld-nt: Can't change dir to 'C:\Program Files\ComOpt\mysql\data\' (Errcode: 2) 020830 14:27:37 Aborting 020830 14:27:37 mysqld-nt: Shutdown Complete This seems to have to do with the file my.ini located in c:\winnt, because if I remove it, it will work. But according to the manual the command line arguments should have higher priority than the config files, or environment varibales. My question is thus, how do I come around this problem and make it possible to run multiple installations of MySQL ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php