The Sakila sample database is available from
http://dev.mysql.com/doc/index-other.html. A downloadable
archive is available in compressed tar file or
Zip format. The archive contains three files:
sakila-schema.sql,
sakila-data.sql, and
sakila.mwb.
The sakila-schema.sql file contains all the
CREATE statements required to create the
structure of the Sakila database including tables, views, stored
procedures, and triggers.
The sakila-data.sql file contains the
INSERT statements required to populate the
structure created by the sakila-schema.sql
file, along with definitions for triggers that must be created
after the initial data load.
The sakila.mwb file is a MySQL Workbench data
model that you can open within MySQL Workbench to examine the
database structure. For more information, see
MySQL
Workbench.
To install the Sakila sample database, follow these steps:
Extract the installation archive to a temporary location such as
C:\temp\or/tmp/. When you unpack the archive, it creates a directory namedsakila-dbthat contains thesakila-schema.sqlandsakila-data.sqlfiles.-
Connect to the MySQL server using the mysql command-line client with the following command:
shell>
mysql -u root -pEnter your password when prompted. A non-
rootaccount can be used as long as the account has privileges to create new databases. -
Execute the
sakila-schema.sqlscript to create the database structure by using the following command:mysql>
SOURCEC:/temp/sakila-db/sakila-schema.sql;Replace
C:/temp/sakila-dbwith the path to thesakila-schema.sqlfile on your system.NoteOn Windows you should use slashes, rather than backslashes, when executing the
SOURCEcommand. -
Execute the
sakila-data.sqlscript to populate the database structure with the following command:mysql>
SOURCEC:/temp/sakila-db/sakila-data.sql;Replace
C:/temp/sakila-dbwith the path to thesakila-data.sqlfile on your system. -
Confirm that the sample database is installed correctly. Execute the following statements. You should see output similar to that shown here.
mysql>
USE sakila;Database changed mysql>SHOW TABLES;+----------------------------+ | Tables_in_sakila | +----------------------------+ | actor | | address | | category | | city | | country | | customer | | customer_list | | film | | film_actor | | film_category | | film_list | | film_text | | inventory | | language | | nicer_but_slower_film_list | | payment | | rental | | sales_by_film_category | | sales_by_store | | staff | | staff_list | | store | +----------------------------+ 22 rows in set (0.00 sec) mysql>SELECT COUNT(*) FROM film;+----------+ | COUNT(*) | +----------+ | 1000 | +----------+ 1 row in set (0.02 sec) mysql>SELECT COUNT(*) FROM film_text;+----------+ | COUNT(*) | +----------+ | 1000 | +----------+ 1 row in set (0.00 sec)
