For this tutorial, use the sakila database
script, which you can find by visiting the
http://dev.mysql.com/doc/ page, selecting the Other
Docs tab, and looking in the Example
Databases section
After downloading the file, extract it to a convenient location.
Open MySQL Workbench and find the menu item by first choosing
and then .
Find and import the sakila-schema.sql file.
This is the script that contains the data definition statements
for the sakila database. The file filter for
the file open dialog window defaults to *.sql
so you should be able to view only files with the
sql extension.
If the file was successfully imported, the application's status
bar reads, Import MySQL Create Script done. To
view the newly imported script, expand the Physical
Schemata section by double-clicking the arrow on the
left of the Physical Schemata title bar. Select
the tab labeled sakila.
You may also wish to remove the default schema tab,
mydb. Select this tab, then click the
button on the upper right in the
Physical Schemata panel.
To view all the objects in the sakila schema,
you may need to expand the Physical Schemata
window. Move the mouse pointer anywhere over the gray area that
defines the lower edge of the Physical
Schemata window. Hold down the right mouse button and
move the mouse to adjust the size of the window.
After you have expanded the window, all the objects in the
sakila database should be visible. Tables
appear at the top followed by views and then routines. There are
no routine groups in this schema, but you should see the
Routine Groups section and an Add
Group icon.
For a complete description of importing a MySQL create script, see Section 9.4.2.1, “Reverse Engineering Using a Create Script”.
So in case that Workbench is freshly opened, it can be found under the Models section at the bottom, by clicking on > 'Create EER Model from Script'.