Hi, currently i got one problem really need your help. I removed mysql3.23.41 version and install mysql 3.23.49. and it works fine with myisam table. Now i am trying to create innobd tables. so i edit my.cnf file like that( window 2000):
[mysqld] basedir=F:/mysql #bind-address=129.128.207.59 datadir=F:/mysql/data #language=F:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # i add these lines innodb_data_home_dir = F:/mysql/ibdata innodb_data_file_path =/ibdata/ibdata1:100M:autoextend:max:2000M set-variable = innodb_buffer_pool_size=150M set-variable = innodb_additional_mem_pool_size=20M innodb_log_group_home_dir = F:/mysql/iblogs innodb_log_arch_dir = F:/mysql/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 #end bincai add [WinMySQLadmin] Server=F:/mysql/bin/mysqld-nt.exe user=system password=password but i when i run mysqld --standalone --console in DOS prompt it give me such error message: InnoDB: syntax error in innodb_data_file_path,020416, can't init databases. I will really appreciate any help. Thanks in advance bin ______________________________________________________________________ Find, Connect Date! http://personals.yahoo.ca --------------------------------------------------------------------- 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
