[mysql] 초기 설치 후 샘플 데이터베이스 설치

http://download.hanbit.co.kr/mysql/5.7/

다운로드

[root@ncloud-server-centos1 tmp]# wget http://download.hanbit.co.kr/mysql/5.7/employees.zip
--2019-02-28 23:08:13--  http://download.hanbit.co.kr/mysql/5.7/employees.zip
Resolving download.hanbit.co.kr (download.hanbit.co.kr)... 218.38.58.196
Connecting to download.hanbit.co.kr (download.hanbit.co.kr)|218.38.58.196|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 36625298 (35M) [application/zip]
Saving to: ‘employees.zip’

100%[=============================================================================================>] 36,625,298  1.17MB/s   in 26s

2019-02-28 23:08:39 (1.34 MB/s) - ‘employees.zip’ saved [36625298/36625298]

[root@ncloud-server-centos1 tmp]# ls -al
total 35908
drwxrwxrwt.  8 root root     4096 Feb 28 23:08 .
dr-xr-xr-x. 18 root root     4096 Jan 25 21:17 ..
-rw-r--r--   1 root root 36625298 May 31  2016 employees.zip

[root@ncloud-server-centos1 tmp]# mkdir employees
[root@ncloud-server-centos1 tmp]# mv employees.zip employees
[root@ncloud-server-centos1 tmp]# cd em*s
[root@ncloud-server-centos1 employees]# ls -al
total 35772
drwxr-xr-x  2 root root       26 Feb 28 23:09 .
drwxrwxrwt. 9 root root     4096 Feb 28 23:09 ..
-rw-r--r--  1 root root 36625298 May 31  2016 employees.zip

[root@ncloud-server-centos1 employees]# unzip employees.zip
Archive:  employees.zip
  inflating: ._employees.sql
  inflating: ._employees_partitioned2.sql
  inflating: ._load_departments.dump
  inflating: ._load_dept_manager.dump
  inflating: ._load_employees.dump
  inflating: ._load_salaries.dump
  inflating: ._load_titles.dump
  inflating: ._README
  inflating: Changelog
  inflating: employees.sql
  inflating: employees_partitioned.sql
  inflating: employees_partitioned2.sql
  inflating: employees_partitioned3.sql
  inflating: load_departments.dump
  inflating: load_dept_emp.dump
  inflating: load_dept_manager.dump
  inflating: load_employees.dump
  inflating: load_salaries.dump
  inflating: load_titles.dump
  inflating: objects.sql
  inflating: README
  inflating: test_employees_md5.sql
  inflating: test_employees_sha.sql
[root@ncloud-server-centos1 employees]#

[root@ncloud-server-centos1 employees]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> \. employees.sql (또는 source employees.sql)
샘플데이터 생성...... 시간 걸림

mysql> \. employees.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected, 6 warnings (0.00 sec)

Query OK, 0 rows affected (0.42 sec)

Query OK, 0 rows affected (0.23 sec)

Query OK, 0 rows affected (0.19 sec)

Query OK, 0 rows affected (0.19 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.17 sec)

+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
1 row in set (0.00 sec)

Query OK, 9 rows affected (0.02 sec)
Records: 9  Duplicates: 0  Warnings: 0

+-------------------+
| INFO              |
+-------------------+
| LOADING employees |
+-------------------+
1 row in set (0.00 sec)

Query OK, 17944 rows affected (6.85 sec)
Records: 17944  Duplicates: 0  Warnings: 0

Query OK, 17938 rows affected (0.68 sec)
Records: 17938  Duplicates: 0  Warnings: 0

Query OK, 17953 rows affected (0.38 sec)
Records: 17953  Duplicates: 0  Warnings: 0

Query OK, 17947 rows affected (0.90 sec)
Records: 17947  Duplicates: 0  Warnings: 0

Query OK, 17948 rows affected (0.64 sec)
Records: 17948  Duplicates: 0  Warnings: 0

Query OK, 17648 rows affected (0.64 sec)
Records: 17648  Duplicates: 0  Warnings: 0

Query OK, 17642 rows affected (0.64 sec)
Records: 17642  Duplicates: 0  Warnings: 0

Query OK, 17638 rows affected (0.95 sec)
Records: 17638  Duplicates: 0  Warnings: 0

Query OK, 17653 rows affected (0.63 sec)
Records: 17653  Duplicates: 0  Warnings: 0

Query OK, 17650 rows affected (1.98 sec)
Records: 17650  Duplicates: 0  Warnings: 0

Query OK, 17636 rows affected (1.27 sec)
Records: 17636  Duplicates: 0  Warnings: 0

Query OK, 17642 rows affected (2.21 sec)
Records: 17642  Duplicates: 0  Warnings: 0

Query OK, 17646 rows affected (0.95 sec)
Records: 17646  Duplicates: 0  Warnings: 0

Query OK, 17642 rows affected (0.59 sec)
Records: 17642  Duplicates: 0  Warnings: 0

Query OK, 17651 rows affected (0.90 sec)
Records: 17651  Duplicates: 0  Warnings: 0

Query OK, 17637 rows affected (2.71 sec)
Records: 17637  Duplicates: 0  Warnings: 0

Query OK, 16209 rows affected (0.82 sec)
Records: 16209  Duplicates: 0  Warnings: 0

+------------------+
| INFO             |
+------------------+
| LOADING dept_emp |
+------------------+
1 row in set (0.00 sec)

Query OK, 24940 rows affected (7.56 sec)
Records: 24940  Duplicates: 0  Warnings: 0

Query OK, 24940 rows affected (2.76 sec)
Records: 24940  Duplicates: 0  Warnings: 0

Query OK, 24940 rows affected (1.04 sec)
Records: 24940  Duplicates: 0  Warnings: 0

Query OK, 24934 rows affected (2.61 sec)
Records: 24934  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (2.44 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (1.21 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (3.67 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (1.64 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (1.14 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (2.10 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (2.19 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (2.69 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 24360 rows affected (1.16 sec)
Records: 24360  Duplicates: 0  Warnings: 0

Query OK, 12609 rows affected (1.35 sec)
Records: 12609  Duplicates: 0  Warnings: 0

+----------------------+
| INFO                 |
+----------------------+
| LOADING dept_manager |
+----------------------+
1 row in set (0.00 sec)

Query OK, 24 rows affected (0.22 sec)
Records: 24  Duplicates: 0  Warnings: 0

+----------------+
| INFO           |
+----------------+
| LOADING titles |
+----------------+
1 row in set (0.00 sec)

Query OK, 21707 rows affected (8.35 sec)
Records: 21707  Duplicates: 0  Warnings: 0

Query OK, 21700 rows affected (2.98 sec)
Records: 21700  Duplicates: 0  Warnings: 0

Query OK, 21687 rows affected (3.56 sec)
Records: 21687  Duplicates: 0  Warnings: 0

Query OK, 21694 rows affected (1.52 sec)
Records: 21694  Duplicates: 0  Warnings: 0

Query OK, 21695 rows affected (1.20 sec)
Records: 21695  Duplicates: 0  Warnings: 0

Query OK, 21700 rows affected (1.72 sec)
Records: 21700  Duplicates: 0  Warnings: 0

Query OK, 21326 rows affected (1.38 sec)
Records: 21326  Duplicates: 0  Warnings: 0

Query OK, 21257 rows affected (2.90 sec)
Records: 21257  Duplicates: 0  Warnings: 0

Query OK, 21245 rows affected (1.44 sec)
Records: 21245  Duplicates: 0  Warnings: 0

Query OK, 21266 rows affected (2.32 sec)
Records: 21266  Duplicates: 0  Warnings: 0

Query OK, 21279 rows affected (3.38 sec)
Records: 21279  Duplicates: 0  Warnings: 0

Query OK, 21251 rows affected (1.63 sec)
Records: 21251  Duplicates: 0  Warnings: 0

Query OK, 21270 rows affected (2.25 sec)
Records: 21270  Duplicates: 0  Warnings: 0

Query OK, 21261 rows affected (2.09 sec)
Records: 21261  Duplicates: 0  Warnings: 0

Query OK, 21251 rows affected (2.09 sec)
Records: 21251  Duplicates: 0  Warnings: 0

Query OK, 21272 rows affected (1.96 sec)
Records: 21272  Duplicates: 0  Warnings: 0

Query OK, 21258 rows affected (2.26 sec)
Records: 21258  Duplicates: 0  Warnings: 0

Query OK, 21252 rows affected (3.06 sec)
Records: 21252  Duplicates: 0  Warnings: 0

Query OK, 21260 rows affected (1.09 sec)
Records: 21260  Duplicates: 0  Warnings: 0

Query OK, 21276 rows affected (2.80 sec)
Records: 21276  Duplicates: 0  Warnings: 0

Query OK, 15401 rows affected (0.51 sec)
Records: 15401  Duplicates: 0  Warnings: 0

+------------------+
| INFO             |
+------------------+
| LOADING salaries |
+------------------+
1 row in set (0.00 sec)

Query OK, 25526 rows affected (8.02 sec)
Records: 25526  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (2.73 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25529 rows affected (0.93 sec)
Records: 25529  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (1.91 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (1.26 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (0.98 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (1.78 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25525 rows affected (2.26 sec)
Records: 25525  Duplicates: 0  Warnings: 0

Query OK, 25531 rows affected (2.64 sec)
Records: 25531  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (1.28 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (0.76 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (2.13 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (1.93 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25529 rows affected (1.23 sec)
Records: 25529  Duplicates: 0  Warnings: 0

Query OK, 25525 rows affected (3.13 sec)
Records: 25525  Duplicates: 0  Warnings: 0

Query OK, 25530 rows affected (0.85 sec)
Records: 25530  Duplicates: 0  Warnings: 0

Query OK, 25529 rows affected (2.07 sec)
Records: 25529  Duplicates: 0  Warnings: 0

Query OK, 25529 rows affected (2.37 sec)
Records: 25529  Duplicates: 0  Warnings: 0

Query OK, 25526 rows affected (1.26 sec)
Records: 25526  Duplicates: 0  Warnings: 0

Query OK, 25530 rows affected (1.69 sec)
Records: 25530  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (4.71 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (0.69 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (0.77 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25527 rows affected (1.02 sec)
Records: 25527  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (3.32 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25530 rows affected (1.31 sec)
Records: 25530  Duplicates: 0  Warnings: 0

Query OK, 25526 rows affected (1.15 sec)
Records: 25526  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (2.68 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (2.59 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25530 rows affected (0.60 sec)
Records: 25530  Duplicates: 0  Warnings: 0

Query OK, 25529 rows affected (3.61 sec)
Records: 25529  Duplicates: 0  Warnings: 0

Query OK, 25530 rows affected (2.14 sec)
Records: 25530  Duplicates: 0  Warnings: 0

Query OK, 25528 rows affected (2.93 sec)
Records: 25528  Duplicates: 0  Warnings: 0

Query OK, 25224 rows affected (1.34 sec)
Records: 25224  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.94 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (0.59 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (2.12 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (3.14 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (0.58 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (0.76 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (4.62 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (0.50 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (1.06 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (1.37 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (7.25 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (0.70 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (0.59 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (1.90 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (1.34 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (2.03 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (1.08 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (2.35 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (1.33 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (1.92 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (0.49 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (3.37 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.64 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (4.00 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (3.28 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.68 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.99 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (3.16 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (3.20 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.58 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.51 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (3.85 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (3.09 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.66 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.79 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (6.20 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.68 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (0.62 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.61 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (4.00 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.52 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.38 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24917 rows affected (2.72 sec)
Records: 24917  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (2.21 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.05 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (1.86 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.61 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (2.69 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (3.57 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (0.74 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (0.60 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (3.39 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (1.97 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.60 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.61 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (2.24 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (2.93 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.75 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24924 rows affected (1.03 sec)
Records: 24924  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (4.54 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (3.46 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (2.59 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (0.85 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (2.59 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (2.44 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24924 rows affected (1.12 sec)
Records: 24924  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (2.69 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.20 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (1.43 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (1.32 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (2.93 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24921 rows affected (0.73 sec)
Records: 24921  Duplicates: 0  Warnings: 0

Query OK, 24922 rows affected (3.53 sec)
Records: 24922  Duplicates: 0  Warnings: 0

Query OK, 24918 rows affected (2.89 sec)
Records: 24918  Duplicates: 0  Warnings: 0

Query OK, 24923 rows affected (0.93 sec)
Records: 24923  Duplicates: 0  Warnings: 0

Query OK, 24924 rows affected (0.78 sec)
Records: 24924  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (1.12 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24920 rows affected (2.15 sec)
Records: 24920  Duplicates: 0  Warnings: 0

Query OK, 24919 rows affected (0.50 sec)
Records: 24919  Duplicates: 0  Warnings: 0

Query OK, 7671 rows affected (0.90 sec)
Records: 7671  Duplicates: 0  Warnings: 0

mysql>

 끝났다...

최초 설치 후 데이터베이스 리스트

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

샘플 데이터베이스 설치 후 리스트

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| employees          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+