Solved

How to use DBDesigner 4?

Posted on 2011-09-03
5
491 Views
Last Modified: 2012-05-12
Hi,

       I have an existing mysql database and i want to have a diagram blueprint so it's easy to understand the database structure for anyone  who has a quick look.


How can i achieve this through DBDesginer version 4  ?
0
Comment
Question by:ee-itpro
[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
5 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 36479480
Why not get mysql's native workbench and create a diagram of the database based on the existing database by connecting?

Have not used DBDesigner in a while so I do not remember on whether the same options outlined above for workbench exist/ed for dbdesigner. I.e. instead of creating the mysql DB structure from scratch whether there was an option to connect to mysql DB and load the data from there?

you could use show create database <database>
and repeat for each table.
Export the database structure/layout and import it.
http://mysqldbnews.blogspot.com/2008/06/free-database-design-tools.html
0
 

Author Comment

by:ee-itpro
ID: 36479711
Workbench not compatible with old OS so unable to install... anyhow i found a very handy  solution that doesn't even need installation :) Thanks for trying.
0
 

Author Comment

by:ee-itpro
ID: 36479727
I've requested that this question be closed as follows:

Accepted answer: 0 points for ee-itpro's comment http:/Q_27290084.html#36479711
Assisted answer: 250 points for arnold's comment http:/Q_27290084.html#36479480

for the following reason:

I knew about Workbench, however since it wasn't compatible with my old OS, i asked about DBDesigner vr. 4.x which is compatible.
0
 

Author Comment

by:ee-itpro
ID: 36479728
Please allocate all 500 points to Arnold since the solution he provided  does work, however i found something before that to help me out.
0
 

Author Closing Comment

by:ee-itpro
ID: 36493361
Thanks
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

751 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