For this tutorial, use the
script, which you can find by visiting the
https://dev.mysql.com/doc/ page, selecting the
Docs tab, and looking in the
After downloading the file, extract it to a convenient location.
Open MySQL Workbench, select the model view from the sidebar in the
home screen, click (>) next to
Models, and then click . 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
If the file was successfully imported, the application's status
Import MySQL Create Script done. To
view the newly imported script, expand the Physical
Schemas section by double-clicking the arrow on the
left of the Physical Schemas title bar.
Select the tab labeled sakila.
You may also wish to remove the default schema tab,
mydb. Select this tab, then click
on the upper right in the
Physical Schemas panel.
To view all the objects in the
you may need to expand the Physical Schemas
panel. Move the mouse pointer anywhere over the gray area that
defines the lower edge of the Physical
Schemas panel. 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
For a complete description of importing a MySQL create script, see Section 18.104.22.168, “Reverse Engineering Using a Create Script”.