?
Solved

Make a data dictionary from phpmyadmin

Posted on 2014-10-16
5
Medium Priority
?
3,944 Views
Last Modified: 2016-09-18
Hi

i think its all in the title.  I need a document with one section per database table giving the conceptual meaning of each field in the table

It seems you can as this guy cant print his
http://sourceforge.net/p/phpmyadmin/bugs/3271/

if it matters my phpmyadmin is is xampp

thanks expert elucidators
0
Comment
Question by:andieje
  • 3
5 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40386037
I looked at 5 different versions of phpMyAdmin including XAMPP and I can't find anything that says "data dictionary" in any of them.  I did find a reference online to "data dictionary" in phpMyAdmin 2.6.0... where are you seeing this?
0
 

Author Comment

by:andieje
ID: 40386194
I was just assuming it was standard being as your fields can have comments. I asssumed theyd have a ncie way to let  you print them off in a document. But it was an assumption
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40386211
Well, you aren't necessarily wrong but I thought you already had something to work with.  It is an interesting idea, I'll do a little more research.  There are a number of pages with comments about the subject.
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 40386246
It turns out that phpMyAdmin does have something it calls a "Data Dictionary" but it's only for each database, not for the entire server.  On the page that lists all the tables in a database, there is a "Data Dictionary" link near the bottom.  It will produce an HTML page with all the info.  You would have to print it out yourself.  See below:
phpMyAdmin "Data Dictionary" link
0
 

Expert Comment

by:Piotr K
ID: 41803601
I recommend you using a proper Data Dictionary generator. Here is a list:
http://datadictionarytools.dataedo.com/data-dictionary-tools-for-mysql
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

621 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