sakila 导入mysql_mysql安装sakila数据库

1、下载种子数据库

下载位置：http://dev.mysql.com/doc/index-other.html

2、安装种子数据库sakila

[root@localhost ~]# unzip sakila-db.zip

注意：如果没有安装unzip需要安装：yum install -y unzip zip

Archive:  sakila-db.zip

creating: sakila-db/

inflating: sakila-db/sakila-schema.sql

inflating: sakila-db/sakila.mwb

inflating: sakila-db/sakila-data.sql

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. Fo