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

Reply via email to