RE: my.ini
Open you're my.ini and correct the values as stated in the event viewer Check the online documentation for the keys and values to set. http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html Regards -Original Message- From: ext Elim PDT [mailto:e...@pdtnetworks.net] Sent: 07 October 2010 04:51 To: mysql@lists.mysql.com Subject: my.ini I recently upgraded mysql from 5.1.9-beta to 5.1.50 Since I used the custom data dir path, my upgrade is basically a replacement of the bin folder and I used the old my.ini file that pointing the data dir to the right path. Then I found, in the event viewer, two warnings: (1) --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release. (2) '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. I mainly used MyISAM tables but have a few of innodb tables. What should I do to correct the my.ini? Thanks for your help. EL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=andrew.2.mo...@nokia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: my.ini
Thanks a lot Andrew. - Original Message - From: andrew.2.mo...@nokia.com To: e...@pdtnetworks.net; mysql@lists.mysql.com Sent: Thursday, October 07, 2010 3:07 AM Subject: RE: my.ini Open you're my.ini and correct the values as stated in the event viewer Check the online documentation for the keys and values to set. http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html Regards -Original Message- From: ext Elim PDT [mailto:e...@pdtnetworks.net] Sent: 07 October 2010 04:51 To: mysql@lists.mysql.com Subject: my.ini I recently upgraded mysql from 5.1.9-beta to 5.1.50 Since I used the custom data dir path, my upgrade is basically a replacement of the bin folder and I used the old my.ini file that pointing the data dir to the right path. Then I found, in the event viewer, two warnings: (1) --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release. (2) '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. I mainly used MyISAM tables but have a few of innodb tables. What should I do to correct the my.ini? Thanks for your help. EL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.2.mo...@nokia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=e...@pdtnetworks.net No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.862 / Virus Database: 271.1.1/3182 - Release Date: 10/07/10 00:34:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: my.ini file for two instances of MySql - need help
At 16:48 + 1/12/04, Rich Brant wrote: Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? This section of the MySQL Reference Manual describes the use of multiple servers: http://www.mysql.com/doc/en/Multiple_servers.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=xxx password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -Original Message- From: Rich Brant [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: my.ini file for two instances of MySql - need help Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? Thank you! BID _ Check out the new MSN 9 Dial-up - fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Thanks, Chris, but how do I refer to the sencond instance of MySQL, the version 4? That's what's not clear to me. I did read the section in the manual, but it doesn't explain how to refer to seperate instances. THanks! From: Chris L. White [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 10:55:21 -0600 Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=xxx password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -Original Message- From: Rich Brant [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: my.ini file for two instances of MySql - need help Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? Thank you! BID _ Check out the new MSN 9 Dial-up - fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Hello, What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0-tree/ datadir = C:/mysql/4.0-tree/data port= 3307 [mysql41] basedir = C:/mysql/4.1-tree datadir = C:/mysql/4.1-tree/data port= 3308 [mysql50] basedir = C:/mysql/5.0-tree datadir = C:/mysql/5.0-tree/data port= 3309 cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.ini file for two instances of MySql - need help
# If you specify no service name, the server uses the default service name of MySQL and the server reads options from the [mysqld] group in the standard option files. # If you specify a service name after the --install option, the server ignores the [mysqld] option group and instead reads options from the group that has the same name as the service. The server reads options from the standard option files. # If you specify a --defaults-file option after the service name, the server ignores the standard option files and reads options only from the [mysqld] group of the named file. http://www.mysql.com/doc/en/Multiple_Windows_servers.html and http://www.mysql.com/doc/en/Multiple_Windows_services.html It sounds like MySQL uses the service name to determine the section of the my.cnf file to pull its settings from. The service name can be set when using the --install option. Follow the second like for an example my.cnf file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 18:28:50 +0100 (CET) Hello, What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0-tree/ datadir = C:/mysql/4.0-tree/data port= 3307 [mysql41] basedir = C:/mysql/4.1-tree datadir = C:/mysql/4.1-tree/data port= 3308 [mysql50] basedir = C:/mysql/5.0-tree datadir = C:/mysql/5.0-tree/data port= 3309 cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.ini
Vicente, language=spanish You could try language=c:/mysql/share/spanish. With my 4.0.7 on Win2K, both works. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Vicente Valero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 8:59 AM Subject: my.ini Hi, This is my 'my.ini' file where I specified 'language=spanish' but the sql errors appear in English yet. I don't see another line after this that changes the value. Can somebody help me? # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 language=spanish #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/mysql/data/ # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - 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
Re: my.ini in RH Linux 7,2
At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. - 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 in RH Linux 7,2
In the last episode (Sep 11), Paul DuBois said: At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. A quick way to find out is to run mysqld --help | grep cnf, which will print a line showing the places my.cnf is read. -- Dan Nelson [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
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
