安装MySQL样本数据库Sakila

朱雀 2022-08-13 06:58 160阅读 0赞

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

1、下载种子数据库  
下载位置：[http://dev.mysql.com/doc/index-other.html][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][root_localhost_none])\]> use sakila

Database changed

[root@localhost\[sakila][root_localhost_sakila]\]> select count(\*) from customer;  
\+----------+  
| count(\*) |  
\+----------+  
|      599 |  
\+----------+  
1 row in set (0.01 sec)

更多参考:  [http://dev.mysql.com/doc/sakila/en/sakila-installation.html][http_dev.mysql.com_doc_sakila_en_sakila-installation.html]

[http_dev.mysql.com_doc_index-other.html]: http://dev.mysql.com/doc/index-other.html
[root_localhost_none]: mailto:root@localhost[%28none
[root_localhost_sakila]: mailto:root@localhost[sakila
[http_dev.mysql.com_doc_sakila_en_sakila-installation.html]: http://dev.mysql.com/doc/sakila/en/sakila-installation.html