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) 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
