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 |
Brian Chandler |
Sep 3 2014, 09:29 AM
Post
#2
|
Jocular coder Group: Members Posts: 2,460 Joined: 31-August 06 Member No.: 43 |
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. |
Lo-Fi Version | Time is now: 19th April 2024 - 02:13 AM |