How to enable relation view in phpmyadmin

Question

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     However anytime when I create a table with my host phpmyadmin  I dont have the option to select  relation view  See below     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

User · Answer

first ensure that your table storage engine type should be innoDB  you can set it using Table operations Tab   if you are using new phpmyadmin then use new  quot Relation view quot  tab to make foreign key relation  if you are using old version of phpmyadmin then the  quot relation view quot  button will show on the bottom of the table columns

User · Answer

1 - Change Your tables search engine from  My ISAM  to  Inno DB  by Operations tab 2 - you must do this for all tables that you want make relationship between 3 - localhost phpmyadmin tbl relation php db your database name amp table your table name then replace this url in browser  then you will be able to see the relationship page

User · Answer

Change your storage engine to InnoDB by going to Operation

User · Answer

If it s too late at night and your table is already innoDB and you still don t see the link  maybe is due to the fact that now it s placed above the structure of the table  like in the picture is shown

User · Answer

first select the table you you would like to make the relation with    then go to operation   for each table there is difference operation setting     inside operation  storage engine  choose innoDB option   innoDB will allow you to view the  relation view  which will help you make the foreign key

User · Answer

Enabling Relation View in phpMyAdmin   MAMP  If you   re using MAMP for your database driven projects you   ll probably be using phpMyAdmin to administer your MySQL database if you   ve decided to go down that route  If you   re creating a database you might be wondering how to create relationships and foriegn keys for your tables   Firstly you need to check that you have access to the Relation view  To do this open phpMyAdmin and select a database  You need to make sure your tables    storage engine is set to use InnoDB  Click on a table within your database and choose the Operations tab  Make sure that the storage engine is set to use InnoDB and save your changes   Now  go back to your table view and click the Structure tab  Depending on your version of phpMyAdmin you should see a link titled Relation view below the table structure  If you can see it you   re good to go  If you can   t you   ll need to follow the steps below to set phpMyAdmin to enable Relations view    Find  Applications MAMP bin phpMyAdmin scripts create tables sql I left this file default but you can change the table name to anything you want  I left mine phpMyAdmin  Open phpMyAdmin and go to the Import tab   Click the browse button and find the create tables sql file and then click Go   The tables required for Relation view will be added to the database you specified   Open  Applications MAMP bin phpMyAdmin config inc php  Find the Server s  configuration code block and replace uncomment the following code and fill in the values  If you left everything default in the create tables sql file then you should just cut and paste the lines below     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history     Save the file and restart MAMP and refresh your phpMyAdmin console  Go to your database and view one of your tables in Structure mode  You should now see the Relation view link    Source  http   newvibes com blog enabling-relation-view-in-phpmyadmin-mamp

[mysql] How to enable relation view in phpmyadmin

Examples related to mysql

Examples related to phpmyadmin