I am stuck! innoDB
Posted: 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?
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?