Help - Search - Members - Calendar
Full Version: phpmyadmin not allowing INNODB as engine
HTMLHelp Forums > Programming > Databases
TysonHorlacher
I am creating a database to hold ecommerce product info. This I am doing as a test on a free parked domain with myphpadmin (podserver.info).

In the phpmyadmin section of this I cannot make my database engine "INNODB" and it remains "MyISAM". I have tried using the SQL alter table engine script

ALTER TABLE tablename ENGINE=INNODB;

This runs but does not change the displayed engine names of my table and they remain "MyISAM'. In further looking I have also found that INNODB is not even an option when I am creating a new table. Those options are (MyISAM--CSV--MGR_MYISAM--BLACKHOLE--MEMORY--ARCHIVE). This is a brand new build with no info in the tables yet. I am just trying to get foreign key relationships correct the first time which I read was to make the engine INNODB. The only change was to make the collation "utf-8-general-ci".

What changes do I need to make to the database to ensure that I can use INNODB as it appears I cannot use it now. If I need to create a new database, that will be fine and I'll remake the table structure I already have.

***Additional Info***
I just tried to create a table entirely through sql (with engine unspecified). It defaults to MyISAM.
Brian Chandler
Have you checked the details of the DB service (I don't really understand what a free parked domain is; someone is providing a DB? free of charge?)

I just tried creating a test table, selecting InnoDB with PhpMyAdmin, and it seems to work. I think the problem is probably not PhpMyAdmin.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2024 Invision Power Services, Inc.