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