MySql报错-Unknown system variable 'storage_engine'
MySql报错-Unknown system variable 'storage_engine'
——墨问苍生
导入测试数据库时出现错误
百度后发现可能是数据库存储引擎不匹配
检查自己的MySQL存储引擎
检查sql文件
发现与数据库不一致
1 set storage_engine = InnoDB; 2 -- set storage_engine = MyISAM; 3 -- set storage_engine = Falcon; 4 -- set storage_engine = PBXT; 5 -- set storage_engine = Maria; 6 7 select CONCAT('storage engine: ', @@storage_engine) as INFO;
修改斜体位置的storage_engine为default_storage_engine
再次执行导入操作
执行成功