Hey, so I have recently become aware that in order to do foreign key relationships, I need to convert my tables over to innodb. I was wanting to do this in phpmyadmin and开发者_开发百科 found the option for 'storage engine (type)' However my dropdown of options is limited to: MyISAM
, MEMORY
, and MRG_MYISAM
Would anyone be able to explain why this is?
apache 2.0
phpmyadmin 3.3.10
mysql 5.0.67
php 5.2.2
Thanks!
InnoDB support has to be enabled on the instance of MySQL you're using.
Try issuing a SHOW ENGINES
SQL command to see what's available.
精彩评论