mysql

导入Mysql示例数据库 employees

Mysql也有跟Oracle的scott与employees相似的数据库，这样就免除了每次都要自己建表并插入数据了。

Mysql提供的供练习使用的数据库employees，下面地址：https://launchpad.net/test-db/employees-db-1/1.0.6
下载其中的employees_db-full-1.0.6.tar.bz2，之后按下列步骤解压缩，并安装。

1、解压文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
[root@rac1 opt]# tar -xjf employees_db-full-1.0.6.tar.bz2 
[root@rac1 opt]# cd employees_db
[root@rac1 employees_db]# ls -al
总计 164724
drwxr-xr-x 2 root root       4096 09-10 19:33 .
drwxr-xr-x 4 root root       4096 09-10 19:33 ..
-rw-r--r-- 1  501 games       752 2009-03-30 Changelog
-rw-r--r-- 1  501 games       161 2008-10-09 ._employees_partitioned2.sql
-rw-r--r-- 1  501 games      6460 2008-10-09 employees_partitioned2.sql
-rw-r--r-- 1  501 games      7624 2009-02-06 employees_partitioned3.sql
-rw-r--r-- 1  501 games      5660 2009-02-06 employees_partitioned.sql
-rw-r--r-- 1  501 games       161 2008-11-28 ._employees.sql
-rw-r--r-- 1  501 games      3861 2008-11-28 employees.sql
-rw-r--r-- 1  501 games       161 2008-07-30 ._load_departments.dump
-rw-r--r-- 1  501 games       241 2008-07-30 load_departments.dump
-rw-r--r-- 1  501 games  13828291 2009-03-30 load_dept_emp.dump
-rw-r--r-- 1  501 games       161 2008-07-30 ._load_dept_manager.dump
-rw-r--r-- 1  501 games      1043 2008-07-30 load_dept_manager.dump
-rw-r--r-- 1  501 games       161 2008-07-30 ._load_employees.dump
-rw-r--r-- 1  501 games  17422825 2008-07-30 load_employees.dump
-rw-r--r-- 1  501 games       161 2008-07-30 ._load_salaries.dump
-rw-r--r-- 1  501 games 115848997 2008-07-30 load_salaries.dump
-rw-r--r-- 1  501 games       161 2008-07-30 ._load_titles.dump
-rw-r--r-- 1  501 games  21265449 2008-07-30 load_titles.dump
-rw-r--r-- 1  501 games      3889 2009-03-30 objects.sql
-rw-r--r-- 1  501 games      2211 2008-07-30 README
-rw-r--r-- 1  501 games       161 2008-07-30 ._README
-rw-r--r-- 1  501 games      4455 2009-03-30 test_employees_md5.sql
-rw-r--r-- 1  501 games      4450 2009-03-30 test_employees_sha.sql

2、安装过程

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[root@rac1 employees_db]# mysql -u root -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

3、检查安装的表有哪些

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
mysql> use employees;
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_employees |
+---------------------+
| departments         |
| dept_emp            |
| dept_manager        |
| employees           |
| salaries            |
| titles              |
+---------------------+
6 rows in set (0.04 sec)