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