I am stuck! innoDB

Problems with the Windows version of XAMPP, questions, comments, and anything related.

I am stuck! innoDB

Postby lmsook » 02. November 2005 19:28

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?
lmsook
 
Posts: 1
Joined: 02. November 2005 19:24

Postby deepsurfer » 02. November 2005 22:18

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.
chirio Deep
Wie sagte einst der MCP aus Tron auf dem Bildschirm zu schreiben Pflegte
" ... end of communication ... "
User avatar
deepsurfer
AF Moderator
 
Posts: 6440
Joined: 23. November 2004 10:44
Location: Cologne
XAMPP Version: 5.6.3
Operating System: Win-XP / Win7 / Linux -Debian

Postby taustin » 02. November 2005 23:22

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.
taustin
 
Posts: 150
Joined: 24. September 2004 00:23
Location: Huntington Beach CA


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 40 guests