安裝MySQL樣本資料庫Sakila

來源:互聯網
上載者:User

安裝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)

更多參考:  http://dev.mysql.com/doc/sakila/en/sakila-installation.html 

--------------------------------------分割線 --------------------------------------

Ubuntu 14.04下安裝MySQL

《MySQL權威指南(原書第2版)》清晰中文掃描版 PDF

Ubuntu 14.04 LTS 安裝 LNMP Nginx\PHP5 (PHP-FPM)\MySQL

Ubuntu 14.04下搭建MySQL主從伺服器

Ubuntu 12.04 LTS 構建高可用分布式 MySQL 叢集

Ubuntu 12.04下原始碼安裝MySQL5.6以及Python-MySQLdb

MySQL-5.5.38通用二進位安裝

--------------------------------------分割線 --------------------------------------

本文永久更新連結地址:

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.