wilkins

老实做人

导航

Mysql示例数据库employees.sql导入问题

Mysql版本:Server version: 5.7.9-log MySQL Community Server (GPL)

问题一、Unknown system variable 'storage_engine'

解决办法:

  line 38 :set storage_engine = InnoDB;   改为 set default_storage_engine = InnoDB;

  line 44 :select CONCAT('storage engine: ', @@storage_engine) as INFO; 改为 select CONCAT('storage engine: ', @@default_storage_engine) as INFO;

 

问题二、Failed to open file 'load_departments.dump'

  参考http://bbs.csdn.net/topics/391040884?page=1ljgstudy的回答,问题出在source 后面文件的路径上

  

改为

     

posted on 2016-01-21 11:22  wilkins  阅读(1336)  评论(0编辑  收藏  举报