Solved

Where did the relationships go in phpmyadmn?

Posted on 2011-03-11
6
316 Views
Last Modified: 2012-05-11
Experts,

I've just discovered the ERD view in phpmyadmin.  It's wonderful!

With some mouse click, however, I've disabled the relationships when I toggle the Small/Big button on the menu.  It's really handy to see the fields along with the relationships, but poof!  they're gone.

They are  still visible in the "small" mode, but the fields aren't.

Can I somehow return to what I enjoyed before?

Capt
0
Comment
Question by:Glen Gibb
  • 4
  • 2
6 Comments
 
LVL 6

Expert Comment

by:Webmonkey
ID: 35119926
I believe what you are looking for can be located by selecting a database, then click on the Designer tab.
0
 

Author Comment

by:Glen Gibb
ID: 35120579
You may have misunderstood.

I have done as you suggested and am in the "Designer" view.  

However, once there, I can no longer see the relationships created between the tables.

Well, I can see them in "Small", but I can't see what fields are joined.  When I toggle "Big", the relationships that were visible a short while ago are no longer visible.

How do I get those relationships back in "Big"?

Capt
0
 
LVL 6

Accepted Solution

by:
Webmonkey earned 500 total points
ID: 35153277
If you aren't see the relationship, then it is probable that the relationship doesn't exist.  Even while in "small" view, you should still see a relationship link between the related tables.  Try going into "big" view and recreating one of the relationships.  If you are able to leave the page, then return to see the relationship, then the original relationships probably aren't there.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:Glen Gibb
ID: 35161757
Tried that.  Went to the "big" view.  The relationships all disappeared, as I described before.

When I attempted to create a new relationship, it failed.   "Error, relationship not added."  I checked carefully to see that I was connecting the primary key to a foreign key.

On the other hand, there is one relationship that stays in view.  And if you click on the table it relates to, it "sticks" to the mouse pointer and will not come unglued!

Wish there were some way to delete tables or clear things out and try again.  That doesn't seem to exist, either.

Capt
0
 

Author Comment

by:Glen Gibb
ID: 35161794
Deleted the db and restored from backup file.  Need to recreate all the relationships, but at least they behave as they should.

Tnx
0
 

Author Closing Comment

by:Glen Gibb
ID: 35161796
Tbx,
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now