I am trying to use mysql-max-3.23.46a for Windows (Win2000) with innodb in use.
After installing from the setup program, I copied "my-example" to c:\my.cnf" and uncommented the innodb lines with the following: innodb_data_file_path = ibdata1:20M innodb_data_home_dir = c:\ibdata\ set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs\ set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs\ innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable=lower_case_table_names =0 set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 When I start the server standalone I get the following: C:\mysql\bin>mysqld-max-nt.exe --standalone Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = /mysql/data/ibdata1:20M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 7.6 at http://www.mysql.com/doc/ I did a search and no other my.cnf files (or my.ini) files are on my disks, so I tried to start the server with the innodb options on the command line and got the following error: C:\mysql\bin>mysqld-max-nt.exe --standalone --innodb_data_file_path=c:\ibdata\ibdata1:20M InnoDB: Warning: operating system error number 123 in a file operation. InnoDB: Cannot continue operation. Any help would be appreciated. Rick Mehalick Sr. Consultant Shell Information Technology International --------------------------------------------------------------------- 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
