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 |
+------------------+
导入时间很慢,比较磨叽,慢慢等吧。