MySQL：官方数据库安装(Employees和sakila)

比眉伴天荒 2022-04-14 02:00 314阅读 0赞

官方提供的数据库：https://dev.mysql.com/doc/index-other.html

### 文章目录 ###

*  安装Employees
 *   *  两种方法下载库
     *  验证
     *  安装
 *  安装sakila

# 安装Employees #

> Employees数据库是一个用于学习和测试的数据库，大约160MB，4百万条记录

[官方文档][Link 1]

## 两种方法下载库 ##

https://github.com/datacharmer/test\_db

*  通过git参考拉取
 *  下载压缩包然后解压：[下载页面][Link 2]  
    这里我使用第一种方法

~/workspace/mysql/employees_git$ git clone https://github.com/datacharmer/test_db.git

![在这里插入图片描述][20190113173724600.png]

## 验证 ##

~/workspace/mysql/employees_git/test_db$ time mysql -uroot -t -p< test_employees_sha.sql 
    Enter password: 
    +----------------------+
    | INFO                 |
    +----------------------+
    | TESTING INSTALLATION |
    +----------------------+
    +--------------+------------------+------------------------------------------+
    | table_name   | expected_records | expected_crc                             |
    +--------------+------------------+------------------------------------------+
    | employees    |           300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
    | departments  |                9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
    | dept_manager |               24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
    | dept_emp     |           331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
    | titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |
    | salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
    +--------------+------------------+------------------------------------------+
    +--------------+------------------+------------------------------------------+
    | table_name   | found_records    | found_crc                                |
    +--------------+------------------+------------------------------------------+
    | employees    |           300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
    | departments  |                9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
    | dept_manager |               24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
    | dept_emp     |           331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
    | titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |
    | salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
    +--------------+------------------+------------------------------------------+
    +--------------+---------------+-----------+
    | table_name   | records_match | crc_match |
    +--------------+---------------+-----------+
    | employees    | OK            | ok        |
    | departments  | OK            | ok        |
    | dept_manager | OK            | ok        |
    | dept_emp     | OK            | ok        |
    | titles       | OK            | ok        |
    | salaries     | OK            | ok        |
    +--------------+---------------+-----------+
    +------------------+
    | computation_time |
    +------------------+
    | 00:00:11         |
    +------------------+
    +---------+--------+
    | summary | result |
    +---------+--------+
    | CRC     | OK     |
    | count   | OK     |
    +---------+--------+
    
    real	0m14.874s
    user	0m0.006s
    sys	0m0.000s

## 安装 ##

~/workspace/mysql/employees_git/test_db$ mysql -t -uroot -p < employees.sql 
    Enter password: 
    +-----------------------------+
    | INFO                        |
    +-----------------------------+
    | CREATING DATABASE STRUCTURE |
    +-----------------------------+

# 安装sakila #

[官方文档][Link 3]

在官网下载页面的 Example Databases 这一栏，可以下载示例数据库。  
[下载页面][Link 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]

将下载文件解压：

$ ls
    sakila-data.sql  sakila.mwb  sakila-schema.sql
    
    $ pwd
    /home/ocean/workspace/mysql/sakila-db

*  sakila-schema.sql文件包含创建sakila数据库结构所需的所有create语句，包括表、视图、存储过程和触发器。
 *  sakila-data.sql文件包含填充由sakila-schema.sql文件创建的结构所需的insert语句，以及初始数据加载后必须创建的触发器的定义。
 *  sakila.mwb文件是一个mysql工作台数据模型，您可以在mysql工作台中打开它来检查数据库结构。  
    登陆MYSQL，安装

mysql> source /home/ocean/workspace/mysql/sakila-db/sakila-schema.sql;
    mysql> source /home/ocean/workspace/mysql/sakila-db/sakila-data.sql;

[Link 1]: https://dev.mysql.com/doc/employee/en/employees-installation.html
[Link 2]: https://dev.mysql.com/doc/index-other.html
[20190113173724600.png]: /images/20220414/64991439c27f448d8969aab84c25f628.png
[Link 3]: https://dev.mysql.com/doc/sakila/en/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: /images/20220414/4ef4c030afe2439daed0ddf593f19526.png