mysql练习用的数据集下载(转载+自己补充步骤)

https://launchpad.net/test-db/employees-db-1/1.0.6

中下载

employees_db-full-1.0.6.tar.bz2

cd employees_db-full-1.0.6

 

employees.sql中

第几行	原始内容	改为
38行	set storage_engine = InnoDB;	set default_storage_engine = InnoDB;
44行	select CONCAT('storage engine: ', @@storage_engine) as INFO;	select CONCAT('default_storage_engine: ', @@default_storage_engine) as INFO;

然后

mysql -uroot -p -t < employees.sql

即可

导入过程如下:

(python2.7) appleyuchi@ubuntu:~/employees_db$ mysql -uroot -p -t < employees.sqlEnter password: 
+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
+--------------------------------+
| INFO                           |
+--------------------------------+
| default_storage_engine: InnoDB |
+--------------------------------+
+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
+-------------------+
| INFO              |
+-------------------+
| LOADING employees |
+-------------------+
+------------------+
| INFO             |
+------------------+
| LOADING dept_emp |
+------------------+
+----------------------+
| INFO                 |
+----------------------+
| LOADING dept_manager |
+----------------------+
+----------------+
| INFO           |
+----------------+
| LOADING titles |
+----------------+
+------------------+
| INFO             |
+------------------+
| LOADING salaries |
+------------------+

导入时间很慢，比较磨叽，慢慢等吧。