开发者

phpmyadmin convert myisam to innodb

开发者 https://www.devze.com 2023-02-19 07:35 出处:网络
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 opti

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消