Solved

Where did the relationships go in phpmyadmn?

Posted on 2011-03-11
6
318 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Read about why website design really matters in today's demanding market.
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…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

776 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