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.
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.
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)