MySQL中安装样本数据库Sakila过程

71 阅读 0 评论 47 点赞

我是靠谱客的博主俊秀眼睛，最近开发中收集的这篇文章主要介绍MySQL中安装样本数据库Sakila过程，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

已经验证，下面可用。

通常情况下对于一个全新的MySQL服务器，没有任何数据供我们测试和使用。对此，MySQL为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在MySQL 5.0以上的版本。以下是其描述。

1、下载种子数据库

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

2、安装种子数据库sakila

复制代码代码如下:

[root@localhost ~]# unzip sakila-db.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. For more information, see MySQL Workbench.
[root@localhost ~]# ls
anaconda-ks.cfg Desktop install.log install.log.syslog sakila-db sakila-db.zip
[root@localhost ~]# cd sakila-db
[root@localhost sakila-db]# ls
sakila-data.sql sakila.mwb sakila-schema.sql
[root@localhost sakila-db]# mysql -uroot -p <sakila-schema.sql
Enter password:
[root@localhost sakila-db]# mysql -uroot -p <sakila-data.sql
Enter password:

3、验证安装结果

复制代码代码如下:

 
 [root@localhost sakila-db]# mysql 
 
 root@localhost[(none)]> show databases; 
 
 +--------------------+ 
 
 | Database           | 
 
 +--------------------+ 
 
 | information_schema | 
 
 | mysql              | 
 
 | performance_schema | 
 
 | sakila             | 
 
 | scottdb            | 
 
 | tempdb             | 
 
 | test               | 
 
 +--------------------+ 
 
 7 rows in set (0.01 sec) 
 
 root@localhost[(none)]> use sakila 
 
 Database changed 
 
 root@localhost[sakila]> show tables; 
 
 +----------------------------+ 
 
 | Tables_in_sakila           | 
 
 +----------------------------+ 
 
 | actor                      | 
 
 | actor_info                 | 
 
 | 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                      | 
 
 +----------------------------+ 
 
 23 rows in set (0.00 sec) 
 
 root@localhost[sakila]> select count(*) from customer; 
 
 +----------+ 
 
 | count(*) | 
 
 +----------+ 
 
 |      599 | 
 
 +----------+ 
 
 1 row in set (0.01 sec)