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