sakila数据库导入失败,执行sakila-data.sql报错
同样没有装好,error1064,这要怎么解决,改sql脚本?
同样没有装好,error1064,这要怎么解决,改sql脚本?
2015-09-11
你好,我的解决方法如下。
sakila-schema.sql 文件注意事项: 当执行命令:mysql>source sakila-schema.sql 后报错: [ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes] 报错后需要修改该表的存储引擎为[MyISAM]单独建表如下(直接复制粘贴即可): CREATE TABLE film_text ( film_id SMALLINT NOT NULL, title VARCHAR(255) NOT NULL, description TEXT, PRIMARY KEY (film_id), FULLTEXT KEY idx_title_description (title,description) )ENGINE=MyISAM DEFAULT CHARSET=utf8; 原因如下: -- -- Table structure for table `film_text` -- -- InnoDB added FULLTEXT support in 5.6.10. If you use an -- earlier version, then consider upgrading (recommended) or -- changing InnoDB to MyISAM as the film_text engine --
举报