Table of Contents [+/-]
MySQL Workbench provides extensive capabilities for creating and manipulating database models, including these:
Create and manipulate a model graphically
Reverse engineer a live database to a model
Forward engineer a model to a script or live database
Create and edit tables and insert data
This is not an exhaustive list. The following sections discuss these and additional data-modeling capabilities.
The Home window is the typical starting point for work with data modeling. In the Data Modeling section of the Workspace, you can use the action items there to create and manage your models.
Open an Existing EER Model: Either click on the model, or launch File, Open Model and locate the model file to open.
Existing models appear as icons in the Model section of the Home page. Click a model icon to load it as a new Model tab.
Create a new EER Model: Click the + icon, or choose File, New Model from the main window.
Create EER Model from Database: Click the > icon from the Home window and choose this option.
Create an EER Model from an existing live database by launching the Reverse Engineer Database wizard. This multi-stage wizard enables you to select a MySQL connection to a live MySQL server, and select schema and objects to reverse engineer into your new model. This is a convenient way to see how an existing database is structured.
Create EER Model from Script: Click the > icon from the Home window and choose this option.
Creates a model from an existing SQL script. The SQL script can be created by hand or by using MySQL Workbench to reverse engineer an existing database. The script may then be modified according to your requirements from the launched Reverse Engineer SQL Script wizard. This is a multi-stage wizard that enables you to select the script you want to create your model from.
To read more about modeling, see Section 7.1, “Model Editor”.