Jim, it must be that the innodb parameters aren't set up in /etc/my.cnf. Case doesn't matter on the "type=innodb". I've set up a tablespace called pracexpr1 that has the following section for innodb in my my.cnf:
# Uncomment the following if you are using Innobase tables innodb_data_file_path = pracexpr1:400M innodb_data_home_dir = /u/sqldata innodb_log_group_home_dir = /u/sqllog innodb_log_arch_dir = /u/sqllog 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 Hope this helps, Larry Irwin CCA Medical sql, query --------------------------------------------------------------------- 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