Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Where did the relationships go in phpmyadmn?

Posted on 2011-03-11
6
Medium Priority
?
337 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 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
In this article, we’ll look at how to deploy ProxySQL.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Suggested Courses

971 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