Hi! Ok, the appropriate parameter
mysqld --defaults-file=your_path_to_my_cnf already exists with which you can explicitly specify what my.cnf file mysqld reads in. Regards, Heikki >Date: Sun, 30 Dec 2001 23:23:18 >To: [EMAIL PROTECTED] >From: Heikki Tuuri <[EMAIL PROTECTED]> >Subject: Re: Multiples instances of MySQL > >Hi! > >You could try the following: make Windows batch files where you give all options to mysqld-max.exe on the command line: > >instance1.bat: > >mysqld-max --port=3306 --socket=... --datadir=... --basedir=... --innodb_data_home_dir=... --set-variable=innodb_buffer_pool_size=30M ... > >instance2.bat: > >mysqld-max --port=3307 --socket=... ... > >I hope we do not run over the command line length limit! But with the above you can get rid of my.ini and my.cnf altogether, or put just the shared starup parameters to my.cnf. > >Actually, Monty should add a startup option to mysqld: > >--read_this_my_cnf=a_path_to_my_cnf_file > >where you could tell from what location this instance of mysqld should read its startup parameters. > >I am forwarding this email to Monty too. He can consider adding the above startup option. Automatically searched my.cnf files cause constant confusion. Having an option to explicitly give the path would help in many situations. > >Regards, > >Heikki Tuuri >Innobase Oy >--- >Order technical MySQL/InnoDB support at https://order.mysql.com/ >See http://www.innodb.com for the online manual and latest news on InnoDB > >>Hello Tony, >> >>Thank you for your note and assistance. >> >>However, I'm stuck on a particular point; >> >>I use Win2k Pro; struggling with 3rd option below, 'server-specific >>options', for multiple instances; MySQL does not see the \mysql\data\my.cnf >>options file, for some reason it only sees c:\winnt\my.ini and c:\my.cnf. >> >> >>Got this from the manual - 4.1.2; >>-------------------------------------------------------- >>Filename Purpose >>windows-system-directory\my.ini Global options >>C:\my.cnf Global options >>C:\mysql\data\my.cnf Server-specic options >>MySQL tries to read option files in the order listed above. If multiple >>option files exist, an option specified in a file read later takes >>precedence over the same option specified in a file read earlier. Options >>specified on the command line take precedence over options specified in any >>option file. Some options can be specified using environment variables. >>Options specified on the command line or in option files take precedence >>over environment variable >>values. >>-------------------------------------------------------- >> >>I cannot see where I'm going wrong; is this possibly a version 4.0.1 option. >>I'm using, 3.23.46-max. >> >>I also looked at 4.7.3, cannot figure out where and how to use mysqld# >>outside the my.cnf options file. >> >>Tony, could you please point me? >> >>Kind regards >>Emmanuel >> >> >>-------------------------------------------------------------------------- ------ >> >> > --------------------------------------------------------------------- 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
