phpmyadmin 中外键的链接
我在 mysql 数据库中设置了外键。我已将数据库从一台服务器备份到新服务器。新旧服务器均使用phpmyadmin。在旧服务器上，y 过去在表视图中具有从外键到另一个表中相应寄存器的链接。一个 html 链接引导我到另一个表中的寄存器。但它不会出现在新服务器上。
有什么想法吗？
I have foreign keys set in a mysql db. I have backed up my db from one server to a new one. Both the new and the old server use phpmyadmin. On the old server, y used to have a link in the view of a table from the foreign key to the respective register in the other table. An html link that leads me to the register in the other table. But it doesn't appear on the new server.
Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您需要设置 pmadb 元表： http://www.phpmyadmin.net /documentation/#linked-tables
之后，您应该在浏览时获得外键之间的链接。您还可以使用 $cfg['Servers'][$i]['relation'] 手动设置想要超链接的关系：
You'll need to set up the pmadb meta-tables: http://www.phpmyadmin.net/documentation/#linked-tables
After that, you should get the links between foreign keys when browsing. You can also use $cfg['Servers'][$i]['relation'] to set up the relations you want hyperlinked by hand: http://www.phpmyadmin.net/documentation/#cfg_Servers_relation
我实在不明白你的意思。为了将数据导入到新的phpMyAdmin，您需要将数据导出到sql并导入导出的sql文件。所有外键仍将保持与您导入的 sql 形式相同。
I don't really get what you mean. In order to import data to a new phpMyAdmin, you need to export the data to sql and import the exported sql file. All the foreign key will still remain the same as what you have imported is in the form of sql.