Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to use DBDesigner 4?

Posted on 2011-09-03
5
Medium Priority
?
517 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 80

Accepted Solution

by:
arnold earned 2000 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

926 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