Solved

Where did the relationships go in phpmyadmn?

Posted on 2011-03-11
6
329 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 

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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
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:
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

627 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