2 messages in com.mysql.lists.win32Problem in configuring InnoDB tables....
FromSent OnAttachments
ales...@virgilio.it21 May 2002 00:23 
Kristean Heisler21 May 2002 11:49 
Subject:Problem in configuring InnoDB tables. Help !
From:ales...@virgilio.it (ales@virgilio.it)
Date:05/21/2002 12:23:32 AM
List:com.mysql.lists.win32

Hi all,

I've got a problem in configuring my.ini file for using InnoDB tables.

I am using mysql ver. 3.23.49 and winnt ws sp6.

I read almost everything from the manual and I was not able to solve the problem.(The problem is the same for both mysqd and mysqld-max-nt)

My 'my.ini' file looks as follows:

----------------------- [mysqld] basedir=C:\mysql datadir=C:\mysql/data innodb_data_home_dir = C:\idb\data innodb_data_file_path = ibdata1:50M innodb_log_group_home_dir = c:\idb\log innodb_log_arch_dir = c:\idb\alog

--------------

For initialising Innodb I run the mysqld (or mysqld-max-nt) from the DOS prompt.

When I use the 'my.ini' file with the lines concerning the InnoDB tables the server does not start and I get the following message in the mysql.err file:

--------------------- InnoDB: Error: you must set the log group home dir in my.cnf the InnoDB: same as log arch dir. 020520 15:47:43 Can't init databases

---------------------------------------

The same thing happens if I use the my.cnf file insted of the my.ini file.

If I erase the line concerning the InnoDB initialization in the 'my.ini' everything is ok and works.

Please help me

Alessio