I Am Stuck! Innodb

[lmsook]

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?

[peterlaursen]

Well …

Is the MySQL database at your local machine or at an ISP or some other remote host ? The MySQL configuration file is normally named my.ini on Windows and my.cnf on Unix/Linux. And it is where the server is! So if you are connecting to a remote host you don't have any my.cnf file!

Some (cheaper) ISP's disable support for InnoDB. I don't know it this is the case or if it is an issue with (the availaable version of) phpmyadmin.

But this is the Webyog forum. Webyog has its own product SQLyog. We don't like people using phpmyadmin 😮

Did you try SQLyog ?

This

QUOTE

the file(my.cnf) in my computer, the type is SpeedDial, which I don't know how to open it to edit … when I installed MySQL(I used XAMPP)

actually confuses me!

I know about these “bundled Apache/php/Mysql packages”, nut never heard about xampp before, but googled and found this http://www.apachefriends.org/en/xampp.html . I don't recommend it! I would get Apache from Apache.org, PHP from php.net and MySQL from mysql.com. Maybe this “bundle” uses a mySQl server binary without support for InnoDB ?

Some specific answers:

1) on Windows and most Linux desktops you can open any file no matter its association by rightclicking .. open with. Open with Notepad (or another texteditor) and save as my.cnf/my.ini NOT mycnf.txt or my.ini.txt !

2) Get the program “MySQL Administrator” from http://dev.mysql.com. It lets you work with the server parameters from a GUI. But I can't be sure that it will work with this bundled verson of MySQL ..

I am not quite sure, but I believe I understand that you installed the XAMMP bundle on a local windows machine, and you don't use other servers? Please confirm!

[peterlaursen]

But this:

QUOTE

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

could indicate that you simply need to comment out the line reading “skip-innodb” and stop and restart the server. That would be the easy way. If the binary code for the InnoDB storage engine is there!

[Author]

Posts