Thomas Henson

  • Data Engineering Courses
    • Installing and Configuring Splunk
    • Implementing Neural Networks with TFLearn
    • Hortonworks Getting Started
    • Analyzing Machine Data with Splunk
    • Pig Latin Getting Started Course
    • HDFS Getting Started Course
    • Enterprise Skills in Hortonworks Data Platform
  • Pig Eval Series
  • About
  • Big Data Big Questions

Reverse Engineering with MySQL Workbench

October 1, 2012 by Thomas Henson 1 Comment

[bra_highlight style=”highlight2″]In this Post we will learn  about reverse engineering with MySQL Workbench on top of an existing MySQL database schema. This is the second part of an ongoing series for using MySQL Workbench to manage databases. Part 1 Setting Up MySQL Workbench [/bra_highlight]

mysql book link

What is database schema

Have you wanted look to see how tables in a database relate to each other or had to update a project with an existing database and no documentation? Well in this second part of our tutorials on MySQL Workbench we are going to create documentation from an existing WordPress database. This documentation will be called an EER (Enhanced Entity Relationship) Diagram but we can just refer to it as our database schema. MySQL Workbench has a wizard that will help us get started with creating this documentation.

Begin Modeling

  1. First we will open up our MySQL Workbench and click on the Create EER Model From Existing Databaseopen eer
  2. We will use the connection we already have stored in MySQL Workbench (Lesson 1)
  3. As we are going through the steps in the Wizard be sure to select only the database we want to Reverse Engineer my example is test
  4. Go through the rest of the Wizard with the default values selected and you should see a screen that looks like this
  5. Now we have to go through and move our tables so we can see them all Select -> Arrange -> Autolayout (pretty awesome isn’t it)
  6. Congratulation we now have an EER Diagram (without relationships we will have to manual add those)

Conclusion

We have just created our own EER for an existing database which counts toward documentation for our project. This process is very simple but powerful tool in MySQL Workbench. Once we set up the EER we can also use it to forward engineer. Try adding a new column or table to the EER then save changes and verify the changes in from the SQL editor window. 


Final Product

dreamhost link

Filed Under: MySQL Tagged With: Database, MySQL, schema, Workbench

Subscribe to Newsletter

Archives

  • February 2021 (2)
  • January 2021 (5)
  • May 2020 (1)
  • January 2020 (1)
  • November 2019 (1)
  • October 2019 (9)
  • July 2019 (7)
  • June 2019 (8)
  • May 2019 (4)
  • April 2019 (1)
  • February 2019 (1)
  • January 2019 (2)
  • September 2018 (1)
  • August 2018 (1)
  • July 2018 (3)
  • June 2018 (6)
  • May 2018 (5)
  • April 2018 (2)
  • March 2018 (1)
  • February 2018 (4)
  • January 2018 (6)
  • December 2017 (5)
  • November 2017 (5)
  • October 2017 (3)
  • September 2017 (6)
  • August 2017 (2)
  • July 2017 (6)
  • June 2017 (5)
  • May 2017 (6)
  • April 2017 (1)
  • March 2017 (2)
  • February 2017 (1)
  • January 2017 (1)
  • December 2016 (6)
  • November 2016 (6)
  • October 2016 (1)
  • September 2016 (1)
  • August 2016 (1)
  • July 2016 (1)
  • June 2016 (2)
  • March 2016 (1)
  • February 2016 (1)
  • January 2016 (1)
  • December 2015 (1)
  • November 2015 (1)
  • September 2015 (1)
  • August 2015 (1)
  • July 2015 (2)
  • June 2015 (1)
  • May 2015 (4)
  • April 2015 (2)
  • March 2015 (1)
  • February 2015 (5)
  • January 2015 (7)
  • December 2014 (3)
  • November 2014 (4)
  • October 2014 (1)
  • May 2014 (1)
  • March 2014 (3)
  • February 2014 (3)
  • January 2014 (1)
  • September 2013 (3)
  • October 2012 (1)
  • August 2012 (2)
  • May 2012 (1)
  • April 2012 (1)
  • February 2012 (2)
  • December 2011 (1)
  • September 2011 (2)

Tags

Agile AI Apache Pig Apache Pig Latin Apache Pig Tutorial ASP.NET AWS Big Data Big Data Big Questions Book Review Books Data Analytics Data Engineer Data Engineers Data Science Deep Learning DynamoDB Hadoop Hadoop Distributed File System Hadoop Pig HBase HDFS IoT Isilon Isilon Quick Tips Learn Hadoop Machine Learning Machine Learning Engineer Management Motivation MVC NoSQL OneFS Pig Latin Pluralsight Project Management Python Quick Tip quick tips Scrum Splunk Streaming Analytics Tensorflow Tutorial Unstructured Data

Follow me on Twitter

My Tweets

Recent Posts

  • Tips & Tricks for Studying Machine Learning Projects
  • Getting Started as Big Data Product Marketing Manager
  • What is a Chief Data Officer?
  • What is an Industrial IoT Engineer with Derek Morgan
  • Ultimate List of Tensorflow Resources for Machine Learning Engineers

Copyright © 2023 · eleven40 Pro Theme on Genesis Framework · WordPress · Log in

 

Loading Comments...