Apache Friends Support Forum

Hi,
Here is my struggle.
I need to have transaction in MySQL, and I've heard that I need to use innoDB, but there is none in phpMyAdmin I can select or change the table type into innoDB.
In the Operations of phpMyAdmin, I know there is a drop down list I can change table type, but I only see MyISAM, Heap, MEMORY, MERGE, MRG_MYISAM.
No innoDB!!
As I run sql "SHOW INNODB STATUS", the result is

#1235 - Cannot call SHOW INNODB STATUS because skip-innodb is defined

As I researched, somebody said about my.cnf, but the file(my.cnf) in my computer, the type is SpeedDial, which I don't know how to open it to edit!!
Oh, I am stuck!
That's maybe when I installed MySQL(I used XAMPP), and I am using MySQL 4.1.14, did I miss something?
Can somebody help me out this?

As I researched, somebody said about my.cnf, but the file(my.cnf) in my computer, the type is SpeedDial, which I don't know how to open it to edit!!

One method is:
- open notepad manuel, then in notepad click on "File" --> Open
- locate \xampp\mysql\bin
- change listing to see all files and then you see "my" to open in notepad.

you can do this with "write" to.

PS: after second read of my text...huuuuuuhh...

many words for one usage...
Open your favorite editor and open the "my" (my.cnf) by manuel files open funktion.

You can also hold down the Shift key, and right-click on the file, and you'll see a "Open with..." entry in the context menu. This will bring up a small windows where you can choose Notepad.