blue-genie Posted April 19, 2010 Share Posted April 19, 2010 Hi all. I'm using xammpp version 1.6.3 with mysql 5.0.45 and php 5.2.3 i've followed this tutorial to try and set up relations etc. http://www.learnphp.org/tutorials/Setting-Up-Foreign-Keys-Using-PhpMyAdmin-63466.html although I've followed this step by step, I can't get that relation view to show up. can anyone provide some pointers. thanks. blu. Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/ Share on other sites More sharing options...
JustLikeIcarus Posted April 19, 2010 Share Posted April 19, 2010 You did define the tables as InnoDB correct? Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1044611 Share on other sites More sharing options...
blue-genie Posted April 20, 2010 Author Share Posted April 20, 2010 Hi no. My type is MyISAM. if i check storage engine, have the following options available memory, blackhole, archive, federated, mrg_myisam. I always leave these as default values. Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045046 Share on other sites More sharing options...
JustLikeIcarus Posted April 20, 2010 Share Posted April 20, 2010 InnoDB is the engine which has to be used for a relational database. This is why you aren't getting those options. Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045100 Share on other sites More sharing options...
blue-genie Posted April 21, 2010 Author Share Posted April 21, 2010 i have tried googling but i cant' find how to change my table type. can you advise? Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045657 Share on other sites More sharing options...
JustLikeIcarus Posted April 21, 2010 Share Posted April 21, 2010 Can you post the contents of you my.cnd config file? Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045904 Share on other sites More sharing options...
blue-genie Posted April 29, 2010 Author Share Posted April 29, 2010 hi sorry i took so long to get back to you. this site is so busy I keep losing my posts. i searched through my xampp folder and I can't find a my.cnd file. Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1050347 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.