如何在MAMP中使用phpMyAdmin在MySQL中显示关系视图 [英] How to display Relation View in MySQL using phpMyAdmin in MAMP

问题描述

好吧，我正在使用数据库，并且有2个表，并且试图在这两个表之间创建一个外部链接.显然，这意味着我需要一个称为关系视图"的按钮，该按钮仅在将两个表都设置为操作"下的InnoDB之后才可见.但是，关系视图无法显示在结构"选项卡下的顶部，或者应该显示的打印"图标旁边的底部.所以我去了这里( http://www. w3expert.com/2008/03/how-to-enable-view-feature-in.html )，并按照说明安装phpmyadmin数据库，该数据库应该已启用关系视图"，但没有启用.所以我迷路了.我想念什么吗?还有另一种方法可以使它起作用吗?

Ok, I've working with my database, and I've got 2 tables and I'm trying to create a foreign link between the two. Apparently this means I need a button called Relation View that is only visible after you set both tables to InnoDB under Operations, which I have done. But Relation View failed to show up, either at the top under the "Structure" tab, or at the bottom next to the "Print" icon where it's supposed to be. So I went here (http://www.w3expert.com/2008/03/how-to-enable-view-feature-in.html) and followed the directions to install the phpmyadmin database, which should have enabled the Relation View, but it didn't. So I'm lost. Am i missing something? Is there another way to get this to work?

为了清楚起见，我正在通过MAMP服务器通过phpMyAdmin进行工作.

To be clear, I'm working through phpMyAdmin through my MAMP server.

编辑-我也按照此网站上的说明进行操作( http://newvibes.com/blog/enabling-relation-view-in-phpmyadmin-mamp/)，并在提到的文件中编辑了服务器配置.

Edit - I've also followed the instructions on this website (http://newvibes.com/blog/enabling-relation-view-in-phpmyadmin-mamp/) and edited the server configurations in the mentioned file.

所以回顾一下- 我已经按照第一个链接中的说明创建了phpmyadmin数据库.然后，我更改了第二个链接中提到的文件的配置.然后，我关闭了phpMyAdmin并重新启动了MAMP服务器.重新打开了所有内容，但仍然无法访问我的关系视图".

So to recap - I've created the phpmyadmin database as per the instructions in the 1st link. Then I changed the configurations of the file mention in the 2nd link. Then I closed my phpMyAdmin and restarted my MAMP server. Reopened everything, and I still can't access my Relation View.

第二次编辑-我一直在搞混phpMyAdmin，并且注意到"Relation View"实际上弹出了我导入的数据库下.但是它不会在任何其他数据库下显示.我应该在导入的数据库中/下创建数据库吗?如果是这样，我该怎么做. . .?

2nd Edit - I've been messing with phpMyAdmin, and I've noticed that "Relation View" actually pops up under the database that I imported. But it doesn't show up under any of the other databases. Am I supposed to create my databases in/under the database I imported? If so, how do I do that . . .?

推荐答案

您是否正在使用MyISAM存储引擎? phpMyAdmin仅显示与InnoDB的关系视图.

Are you using MyISAM storage engine? phpMyAdmin only shows relational view with InnoDB.

单击一个表，转到顶部的操作"，然后将存储引擎"更改为InnoDB.我想您一次只能做一张桌子

Click on a table, go to Operations at the top and change Storage Engine to InnoDB. I think you can only do this one table at a time

对于大型数据库，InnoDSB有很多开销(据我了解)，但对于中小型数据库来说应该没问题.

InnoDSB has a lot of overheads for larger databases (so I understand) but should be fine for small/medium stuff.

这篇关于如何在MAMP中使用phpMyAdmin在MySQL中显示关系视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！