Hi! Maybe you already have a my.ini or my.cnf file in winnt or winnt\system directory, or some other directory and that overshadows the file you have in C:\ What do dir /s my.cnf dir /s my.ini say? Your innodb start options look ok. For some reason MySQL does not see the options you have specified. Regards, Heikki http://www.innodb.com Copied message: ................ I read the mannual to use InnoDB. following is my c:\my.cnf file. I am still getting above message. I tried with 3.23.39a-win and also with mysql-3.23.41-win.zip. I do have data and logs directory created. Please help vitthal # Example mysql config file for medium systems.# # This is for a system with little memory (32M - 64M) where MySQL plays # a important part and systems up to 128M very MySQL is used togetherwith # other programs (like a web server)## You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options.# # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option.# The following options will be passed to all MySQL clients [client]#password = your_passwordport = 3306#socket = /tmp/mysql.sock # Here follows entries for some specific programs# The MySQL server[mysqld] port = 3306#socket = /tmp/mysql.sockskip-lockingset-variable = key_buffer=64M set-variable = max_allowed_packet=1Mset-variable = table_cache=64 set-variable = sort_buffer=4Mset-variable = record_buffer=1M set-variable = net_buffer_length=8Kset-variable = myisam_sort_buffer_size=8M # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:/mysql/dataset-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/mysql/logs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30Mset-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1innodb_log_arch_dir = c:/mysql/logs innodb_log_archive=0set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M 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=20Mset-variable = read_buffer=2M set-variable = write_buffer=2M[myisamchk]set-variable = key_buffer=20M set-variable = sort_buffer=20Mset-variable = read_buffer=2M set-variable = write_buffer=2M[mysqlhotcopy]interactive-timeout --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
