phpmyadmin not allowing INNODB as engine |
phpmyadmin not allowing INNODB as engine |
TysonHorlacher |
Sep 3 2014, 06:32 AM
Post
#1
|
Group: Members Posts: 9 Joined: 15-October 13 Member No.: 19,856 |
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. This post has been edited by TysonHorlacher: Sep 3 2014, 06:52 AM |
Lo-Fi Version | Time is now: 20th May 2024 - 05:24 PM |