Hi,
I'm sorry to trouble you, I was upgrade from mysql 4.01 to 4.02 in
mandrake 8.2.
The following options in current running my.cnf suddently not work:
innodb_data_file_path = ibdata1:100M
innodb_data_home_dir = /data/mysql/
innodb_log_group_home_dir = /data/mysql/
innodb_log_arch_dir = /data/mysql/
innodb_flush_log_at_trx_commit = 1
innodb_log_archive = 0
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=4M
set-variable = innodb_log_buffer_size=4M
set-variable = innodb_buffer_pool_size=64M
set-variable = innodb_additional_mem_pool_size=4M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = innodb_thread_concurrency=8
I change the 1st:
innodb_data_file_path = ibdata1:100M
To
innodb_data_file_path = /data/mysql/ibdata1:100M:autoextend
I have to remark rest options in order to make it working and also
"set-variable = " seen not needed??
The err log show:
ERROR: unknown variable '..................' whenever I keep any options
other than the 1st line,
All previous section section is working when remove 'set-variable = '.
So the problem isolated to innodb options sections and seen no doc
refer this change, would u kind enough to give me a hand.
Most of the options is copy from example config file with minor
changes....It is working in 4.0 4.01 and suddently not work now.
Thanks.
Please reply to [EMAIL PROTECTED]
---------------------------------------------------------------------
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
