MySQL 樣本資料庫sakila-db的安裝

標籤：type   cto   div   highlight   ace   lib   htm   nec   sdn   

最近在看 “高效能MySql”這本神書,發現上面很多例子採用的官方樣本資料庫sakila。

官方樣本資料庫 

http://dev.mysql.com/doc/index-other.html

Documenation - Other Docs - Example Databases 樣本庫和文檔放到了一起  跳轉到下載介面。

解壓匯入sakila資料庫

上傳檔案到任意路徑下

 

 

[[email protected] etc]# ll總用量 756-rw-r--r-- 1 root   root   741613 7月   6 17:53 sakila-db.zip

 

　　

 

解壓檔案

 

[[email protected] etc]# unzip sakila-db.zip Archive:  sakila-db.zip   creating: sakila-db/  inflating: sakila-db/sakila-data.sql    inflating: sakila-db/sakila-schema.sql    inflating: sakila-db/sakila.mwb 

　　

解壓後，可以看見有如下檔案

[[email protected] sakila-db]# ll總用量 3396-rw-r--r-- 1 root root 3398148 7月  21 2016 sakila-data.sql-rw-r--r-- 1 root root   50019 7月  21 2016 sakila.mwb-rw-r--r-- 1 root root   23424 7月  21 2016 sakila-schema.sql

　　

匯入sql檔案

  

[[email protected] sakila-db]#  mysql -uroot -p <sakila-schema.sqlEnter password: [[email protected] sakila-db]# mysql -uroot -p <sakila-data.sqlEnter password: [[email protected] sakila-db]# 

　檢查匯入的資料是否成功(兩種檢測方法任選一種就可以)

 

[[email protected] sakila-db]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 30659Server version: 5.6.36-log Source distributionCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql> mysql> mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || jfedu              || mysql              || performance_schema || sakila             || test               || zabbix             |+--------------------+7 rows in set (0.01 sec)mysql> use sakilaReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> 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)mysql> 

　　樣本資料庫匯入完成

MySQL 樣本資料庫sakila-db的安裝