Solved

How to use DBDesigner 4?

Posted on 2011-09-03
5
489 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
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

680 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