Solved

Where did the relationships go in phpmyadmn?

Posted on 2011-03-11
6
321 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
How our DevOps Teams Maximize Uptime

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

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

830 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