1286 - Unknown storage engine 'MongoDB' while migrating to MySQL

93 Views Asked by At

I am using MySQL migration tool to migrate my data from MongoDB (via MongoDB BI connector) to MySQL.

All first steps performed well.

At Create Schemas step, I get the warning

Unknown storage engine 'MongoDB'.
SQL Error: 1286

And at Create Target Results step, the SQL scripts to create tables fail with the same error output.

Example of query that fails:

CREATE TABLE IF NOT EXISTS `trainingDB`.`gradings` (
  `_studentId` VARCHAR(65535) NULL DEFAULT NULL COMMENT '{ \"name\": \"studentId\" }',
  `_sessionId` VARCHAR(65535) NULL DEFAULT NULL COMMENT '{ \"name\": \"sessionId\" }')
ENGINE = MongoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin
COMMENT = '{ \"collectionName\": \"gradings\" }'
0

There are 0 best solutions below