phpmyadmin not supporrting INNODB

[shoonya]

Hi all,

By default my tables are getting stored as MYISAM though i am forcing

create table foo (
.....
.....
) TYPE = INNODB;

how to make INNODB as default engine

[shoonya]

http://www.mydigitalli fe.info/2006/10/21/enable-mysql-innodb-storage-engine-support-in-xampp-installation/

I got this link but the file my.cnf is not present in my directory :(

[mwasif]

but the file my.cnf is not present in my directory :(

Where you are looking for my.cnf? If you are on windows then it should be my.ini not my.cnf.

[shoonya]

Where you are looking for my.cnf? If you are on windows then it should be my.ini not my.cnf.

my.ini

is not present anywhere in the xampp folder
:(
[ I am windowx XP ]

[mwasif]

I never used XAMPP but I found a user comment related to your query on mysql.com:-)

Look for the batch file mysql_start.bat in the xampp directory. My mysql_start.bat file includes this line:
mysql\bin\mysql d --defaults-file=mysql\bin\ my.cnf --standalone --console

[shoonya]

it didn't help me
but anyways thanks for replying

[mwasif]

Check the my.ini/my.cnf files at the following locations

1. Windowns Install Dir\my.ini
2. C:\my.cnf

Or use Windows search option

If you are unable to find any such file, then create a new one.

[esco00]

Windows recognizes the cnf extension as a speed dial file for netmeeting and a frontpage file. you might not see the extension .cnf, instead you will probably see an icon of sorts called "my". this is the file you want, just open notepad and drag n drop the file in it. it will open up the config file.