I Am Stuck! Innodb

[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