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 models, forward and reverse engineer, and compare and synchronize schemata:
Open an Existing EER Model: Either click on
the model, or launch the
Open Workbench Model
and locate the model file to open.
If you have already created one or more model files, each will appear in the Model section of the Home page as an icon. Clicking the item of the model you wish to load creates a new MySQL Model tab and displays your model.
Create a new EER Model: Click the [+] icon,
or choose File, New
Model from the main window.
Create EER Model from an Existing Database:
Click the [>] icon from the Home window and choose this option.
This enables you to create an EER Model from an existing live database by launching the Reverse Engineer Database wizard. This is a multi-stage wizard that enables you to select a connection to a live server, and select the schema and objects you wish to reverse engineer into your new model. This is a convenient way to see how an existing database is structured.
Create EER Model from SQL Script: Click the
[>] icon from the Home window and choose this option.
This allows you to create a model from an SQL Create script. Such a script may have been created by hand or as a result of reverse engineering an existing database. The script may then be modified according to requirements. This also launches the 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 9.1, “Model Editor”.