MySQL安装示例employee数据库-创新互联

服务器操作系统:CentOS release 6.8 (Final)

创新互联公司于2013年创立,先为云梦等服务建站,云梦等地企业,进行企业商务咨询服务。为云梦企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

数据库系统:MySQL 5.5.52

任务:安装employee示例数据库

操作步骤:

[root@sky9896 ~]# wget https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2

[root@sky9896 ~]#tar jxf employees_db-full-1.0.6.tar.bz2

[root@sky9896 ~]# cd employees_db

[root@sky9896 employees_db]# mysql -uroot  -p  -t #导入数据库

Enter password:

+-----------------------------+

| INFO             |

+-----------------------------+

| CREATING DATABASE STRUCTURE |

+-----------------------------+

+------------------------+

| INFO          |

+------------------------+

| storage engine: InnoDB |

+------------------------+

+---------------------+

| INFO         |

+---------------------+

| LOADING departments |

+---------------------+

+-------------------+

| INFO        |

+-------------------+

| LOADING employees |

+-------------------+

+------------------+

| INFO       |

+------------------+

| LOADING dept_emp |

+------------------+

+----------------------+

| INFO         |

+----------------------+

| LOADING dept_manager |

+----------------------+

+----------------+

| INFO      |

+----------------+

| LOADING titles |

+----------------+

+------------------+

| INFO       |

+------------------+

| LOADING salaries |

+------------------+

[root@sky9896 employees_db]# time mysql -uroot  -p  -t < 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     |

+--------------+---------------+-----------+

real   0m19.958s

user   0m0.005s

sys   0m0.009s

另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。


标题名称:MySQL安装示例employee数据库-创新互联
路径分享:http://scyanting.com/article/hihpi.html