I am having some problems in getting mysql to initaiate the inodb option. The relevant section of my.cnf is: # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = / innodb_data_file_path = data1/ibdata1:100M:autoextend;data2/ibdata2:100M:autoextend;data3/ibdata3:10 0M:autoextend innodb_log_group_home_dir =index1/ innodb_log_arch_dir = index1/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high set-variable = innodb_buffer_pool_size=256M set-variable = innodb_additional_mem_pool_size=20M # Set .._log_file_size to 25 % of buffer pool size set-variable = innodb_log_file_size=64M set-variable = innodb_log_buffer_size=8M set-variable = innodb_log_files_in_group=4 innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 set-variable = innodb_file_io_threads=4
My system has the following mount points for database files. /data1, /data2, /data3, /index1, /index2 mysql user can create files in all of these mount points. The errors from starting mysql are; 020920 14:28:56 mysqld started 020920 14:28:56 InnoDB: syntax error in innodb_data_file_path 020920 14:28:56 Can't init databases 020920 14:28:56 mysqld ended 020920 14:39:45 mysqld started 020920 14:39:45 InnoDB: syntax error in innodb_data_file_path 020920 14:39:45 Can't init databases 020920 14:39:45 mysqld ended 020920 14:55:31 mysqld started 020920 14:55:31 InnoDB: syntax error in innodb_data_file_path 020920 14:55:31 Can't init databases 020920 14:55:31 mysqld ended Can anyone tell me what the problem is? Regards Peter Goggin --------------------------------------------------------------------- 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