Employee数据库导入

一、下载

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

 登陆MySQL数据库官网，下载测试库

 下载地址：https://github.com/datacharmer/test_db

二、上传解压

[root@mysql soft]# unzip test_db-master.zip 

三、执行文件前给employees.sql文件加  set autocommit=1

set autocommit=1
DROP DATABASE IF EXISTS employees;
CREATE DATABASE IF NOT EXISTS employees;
USE employees;

SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

DROP TABLE IF EXISTS dept_emp,
                     dept_manager,
                     titles,
                     salaries, 
                     employees, 
                     departments;

/*!50503 set default_storage_engine = InnoDB */;
/*!50503 select CONCAT('storage engine: ', @@default_storage_engine) as INFO */;

执行文件

[root@mysql test_db-master]# mysql -uroot -p < employees.sql
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
data_load_time_diff
00:01:18

四、核验数据，OK表示没有问题

[root@mysql test_db-master]# mysql -uroot -p <test_employees_sha.sql 
Enter password: 
INFO
TESTING INSTALLATION
table_name    expected_records    expected_crc
departments    9    4b315afa0e35ca6649df897b958345bcb3d2b764
dept_emp    331603    d95ab9fe07df0865f592574b3b33b9c741d9fd1b
dept_manager    24    9687a7d6f93ca8847388a42a6d8d93982a841c6c
employees    300024    4d4aa689914d8fd41db7e45c2168e7dcb9697359
salaries    2844047    b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f
titles    443308    d12d5f746b88f07e69b9e36675b6067abb01b60e
table_name    found_records       found_crc
departments    9    4b315afa0e35ca6649df897b958345bcb3d2b764
dept_emp    331603    d95ab9fe07df0865f592574b3b33b9c741d9fd1b
dept_manager    24    9687a7d6f93ca8847388a42a6d8d93982a841c6c
employees    300024    4d4aa689914d8fd41db7e45c2168e7dcb9697359
salaries    2844047    b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f
titles    443308    d12d5f746b88f07e69b9e36675b6067abb01b60e
table_name    records_match    crc_match
departments    OK    ok
dept_emp    OK    ok
dept_manager    OK    ok
employees    OK    ok
salaries    OK    ok
titles    OK    ok
computation_time
00:01:27
summary    result
CRC    OK
count    OK

五、加MD5校验

[root@mysql test_db-master]# mysql -uroot -p< test_employees_md5.sql 
Enter password: 
INFO
TESTING INSTALLATION
table_name    expected_records    expected_crc
departments    9    d1af5e170d2d1591d776d5638d71fc5f
dept_emp    331603    ccf6fe516f990bdaa49713fc478701b7
dept_manager    24    8720e2f0853ac9096b689c14664f847e
employees    300024    4ec56ab5ba37218d187cf6ab09ce1aa1
salaries    2844047    fd220654e95aea1b169624ffe3fca934
titles    443308    bfa016c472df68e70a03facafa1bc0a8
table_name    found_records       found_crc
departments    9    d1af5e170d2d1591d776d5638d71fc5f
dept_emp    331603    ccf6fe516f990bdaa49713fc478701b7
dept_manager    24    8720e2f0853ac9096b689c14664f847e
employees    300024    4ec56ab5ba37218d187cf6ab09ce1aa1
salaries    2844047    fd220654e95aea1b169624ffe3fca934
titles    443308    bfa016c472df68e70a03facafa1bc0a8
table_name    records_match    crc_match
departments    OK    ok
dept_emp    OK    ok
dept_manager    OK    ok
employees    OK    ok
salaries    OK    ok
titles    OK    ok
computation_time
00:01:22
summary    result
CRC    OK
count    OK