Mysql 4.X does not needs any setting in the my.ini to initlize DB leave it all empty. (Provided you did just Next next and Next when installing and installed it to c:\mysql)

What you need to do is when you create Tables just set the type=InnoDB to have transcation enabled

Regards

Nikhil bhaskaran wrote:

O/s : Windows 2000 professional ( Dont kill me for that , i know this is linux forum , but i thought someone might still know )

I am using this code in my.ini file

[mysqld] innodb_data_home_dir = C://mysql//data ( have tried with single forward slash to , somewhere google said use 2 slashes so tried that too) innodb_data_file_path = ibdata1:10M:autoextend

---

That's funny. I have been using Mysql in Linux/BSD/Windows for almost 1 yr now and never encountered this. What version of Mysql are you using.

few correction from your previous post leave the innodb_data_home_dir as innodb_data_home_dir = and in next line add innodb_data_file_path = ibdata1:10M:autoextend

Here is my.ini from c:\windows\my.ini from one of my Windows server

-------------------------------------my.ini-------------------- [mysqld-nt] basedir=c:/mysql/ datadir=c:/mysql/data set-variable = log_bin=On server-id=1 innodb_data_home_dir = innodb_data_file_path = ibdata/ibdata1:100M:autoextend:max:2000M

[mysqld] basedir=c:/mysql/ datadir=c:/mysql/data set-variable = log_bin=On server-id=1 innodb_data_home_dir = innodb_data_file_path = ibdata/ibdata1:100M:autoextend:max:2000M

[WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe

-------------------------------------my.ini--------------------

If this does not works either file <filename.err> in c:\mysql\data (filename is the name of the NetBIOS name of the system)

Dont confuse if you still see folder name as database name and has MYD and MYI in data folder. This is perfectly normal

Do some simple test such as issuing a begin; <Some insert statement>; and then Rollback; instead of commit. The insert would have failed

And in event if any body has troubles due to Windows discussion in the list reply me directly.

Regards

Nikhil bhaskaran wrote:

Thanks for the suggestion, but that is what i did intially, i installed mysql 4 without amking any changes , next , next next as u said , post installation when i gave a command to create a table as type innodb , it created a table without giving any error , but then when we checked the type of talbe what is created it was still myisam , that is when we started searching google and found recommendations to add all that to my.ini , but it still didnt work thanks again for ur help , but my issue remains