Hello alessio, Tuesday, May 21, 2002, 10:23:54 AM, you wrote:
aavi> Hi all, aavi> I've got a problem in configuring my.ini file for using InnoDB tables. aavi> I am using mysql ver. 3.23.49 and winnt ws sp6. aavi> I read almost everything from the manual and I was not able to solve the aavi> problem.(The problem is the same for both mysqd and mysqld-max-nt) aavi> My 'my.ini' file looks as follows: aavi> ----------------------- aavi> [mysqld] aavi> basedir=C:\mysql aavi> datadir=C:\mysql/data aavi> innodb_data_home_dir = C:\idb\data aavi> innodb_data_file_path = ibdata1:50M aavi> innodb_log_group_home_dir = c:\idb\log aavi> innodb_log_arch_dir = c:\idb\alog aavi> -------------- aavi> For initialising Innodb I run the mysqld (or mysqld-max-nt) from the DOS aavi> prompt. aavi> When I use the 'my.ini' file with the lines concerning the InnoDB tables aavi> the server does not start and I get the following message in the mysql.err aavi> file: aavi> --------------------- aavi> InnoDB: Error: you must set the log group home dir in my.cnf the aavi> InnoDB: same as log arch dir. aavi> 020520 15:47:43 Can't init databases aavi> --------------------------------------- aavi> The same thing happens if I use the my.cnf file insted of the my.ini file. aavi> If I erase the line concerning the InnoDB initialization in the 'my.ini' aavi> everything is ok and works. aavi> Please help me aavi> Alessio aavi> --------------------------------------------------------------------- aavi> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before aavi> posting. To request this thread, e-mail [EMAIL PROTECTED] aavi> To unsubscribe, send a message to the address shown in the aavi> List-Unsubscribe header of this message. If you cannot see it, aavi> e-mail [EMAIL PROTECTED] instead. hi I use Win2000 MySQL Max 3.23.49 and c:\winnt\my.ini MySQL Max it is installed by serves. mysql-max-nt.exe. I start tools with correct my.ini and through mysql.exe I receive access to base. The part my.ini which correctly is below given works. But I start MySQL from Win instead of from a DOS. innodb_data_file_path = ibdata1:200M;ibdata2:200M innodb_data_home_dir = d:\fomin\InnoDB\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = d:\fomin\InnoDB\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = d:\fomin\InnoDB\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 -- Best regards, maxim mailto:[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