How to enable relation view in phpmyadmin

mysql phpmyadmin
NeverPhased picture NeverPhased · Dec 7, 2011 · Viewed 147.8k times · Source

When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after clicking on the structure tab. See below:

enter image description here

However anytime when I create a table with my host phpmyadmin, I dont have the option to select "relation view" See below:

enter image description here

Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work.

Answer

Harley picture Harley · Sep 11, 2012

Change your storage engine to InnoDB by going to Operation

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys. I created …

Read More