Solved

Make a data dictionary from phpmyadmin

Posted on 2014-10-16
5
3,235 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
[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
  • 3
5 Comments
 
LVL 83

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 83

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 83

Accepted Solution

by:
Dave Baldwin earned 500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

690 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