MySQL示例数据库sakila-db的安装导入

MySQL示例数据库sakila-db的安装导入

---

---

下载： https://dev.mysql.com/doc/index-other.html    或   http://downloads.mysql.com/docs/sakila-db.zip

[root@LHRDB tmp]# 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     [root@LHRDB tmp]# cd sakila-db [root@LHRDB sakila-db]# ll total 3396 -rw-r--r-- 1 root root 3398148 Jul 21  2016 sakila-data.sql -rw-r--r-- 1 root root   50019 Jul 21  2016 sakila.mwb -rw-r--r-- 1 root root   23424 Jul 21  2016 sakila-schema.sql [root@LHRDB sakila-db]# mysql < sakila-schema.sql [root@LHRDB sakila-db]# mysql < sakila-data.sql [root@LHRDB sakila-db]# mysql  Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | db_name            | | db_name2           | | lhrdb              | | mysql              | | performance_schema | | sakila             | | sys                | +--------------------+ 8 rows in set (0.05 sec) mysql> use sakila; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> 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> select count(*) from customer; +----------+ | count(*) | +----------+ |      599 | +----------+ 1 row in set (0.00 sec)

---

---

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

 
  
   
     
 

 
   
  

<

 

 
 
 
  
 
 

 

<

---

---

&