For this tutorial use the sakila
database
script found in the Example Databases
section
of the http://dev.mysql.com/doc/ page.
After downloading the file, extract it to a convenient location.
Open MySQL Workbench and find the Reverse Engineer MySQL
Create Script menu option by first selecting
File and then Import. 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 only be able to view 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 labelled sakila.
Yo may also wish to remove the default schema tab,
mydb
. Do this by selecting this tab and then
clicking 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. To do this 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.
Once you've 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 7.5.9.1, “Reverse Engineering Using a Create Script”.