Re: my.ini vs. my.cnf on Winodws?
On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote: Hi! Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Thanks for the clarification, Monty. Will it read *both* files if they exist, then? Just like /etc/my.cnf and datdir/my.cnf on Unix platforms? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 335,941,996 queries (270/sec. avg) - 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
Re: my.ini vs. my.cnf on Winodws?
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote: Hi! Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Jeremy Thanks for the clarification, Monty. Jeremy Will it read *both* files if they exist, then? Just like /etc/my.cnf Jeremy and datdir/my.cnf on Unix platforms? Yes; (That was what I tried to write) Regards, Monty - 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
Re: my.ini vs. my.cnf on Winodws?
Michael Widenius writes: Hi! MySQL will first read systemdir\my.ini and then C:\my.cnf Sorry, Sinisa, you can't get things right every time ;) (No one can...) I have updated the manual regarding this. Regards, Monty Yes, you are right. I looked a bit better. Only if some other default config file is provided at startup (--defaults-file=...) then that one is read instead of systemdir\my.ini. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: my.ini vs. my.cnf on Winodws?
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeremy Zawodny writes: According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? cut Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Sorry, Sinisa, you can't get things right every time ;) (No one can...) I have updated the manual regarding this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - 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
Re: my.ini vs. my.cnf on Winodws?
Jeremy, I have version 3.23.41 installed on Win2K. The installation program may have been corrected since (I hope so!), but when I installed it it did the following: - It created my_cnf in C:\ even though I told the installation program I wanted to install on F: and the system drive is R: (*nothing* should be installed in C:\ in that situation!) - It created my-example.cnf in the program installation directory - but with incorrect paths in it (see below) - instructions in both these files mention only C:\mycnf - no reference to my.ini - It created my.ini in R:\ (the *root* of the system drive, not my %WinDir% directory); I didn't find this until later, because that's not where a configuration file should be: I didn't even look there. It did not have an [mysqld] section at all (I had to copy that from my_cnf/my-example.cnf), and though the default is to not use innodb, it --and my_cnf-- lacked the statement skip-innodb making it impossible to even get mysqld started. - I also found mysqld.trace in R:\ - it has no business being there either. (In fact, I also had to *tell* the installation program that it should install on F: even though that is indicated in the Registry as the program installation path. This is incorrect behavior for a Windows installation program: it should look in the Registry to present a default program installation location.) Apart from that, the files that are installed did not have content that corresponded with the actual installation. That is not necessary - such files can be simply *generated* from the installation using the actual installation paths as given by the user. For instance this instruction is not only wrong (unless you happened to install on D:\), but completely unnecessary: ~~~ # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ ~~~ The file could simply have been generated with the *actual* location for basedir. The MySqlManager.exe program (correctly) expects a file my.ini in the %WinDir% directory; I had to create that before I could use the program. Final note: The whole situation illustrates Unix-centric thinking. The problem is that the results badly confuse both beginning and experienced Windows users - especially if they have no experience with Unix. If a Windows program uses a configuration file at all (instead of the Registry) they expect to find [programname].ini in their %WinDir% directory because that's where they belong and what they should be called - not in the root of any drive. The names my.cnf and my.ini are badly chosen. my normally indicates of mine (My Documents, My Pictures...); if you see a file called my.ini you think my what?. Configuration files should be named after the program the configuration is for. So we should actually have mysql.ini (and only mysql.ini). An installation program should also make sure the application can at least be immediately started in a default configuration. At 08:56 2002-01-14, you wrote: According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? Here's the part I'm reading: There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both files are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. If I had a suitable system handy to install on, I'd just install it and try (of course). Can anyone shed some light on this? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 261,751,768 queries (266/sec. avg) - 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 -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: my.ini vs. my.cnf on Winodws?
Jeremy Zawodny writes: According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? Here's the part I'm reading: There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both files are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. If I had a suitable system handy to install on, I'd just install it and try (of course). Can anyone shed some light on this? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 261,751,768 queries (266/sec. avg) Hi! my.cnf will be read first and if it is found my.ini will not be read at all. Take a look at mysys/default.c for futher details ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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