Access to MySQL - ENGINE = InnoDB syntax error

[Billy Fogo]

Please bear with me i am extremely new at this migration stuff.

I utilized the migration tool to migrate from an Access db to a MySQL db. i there was an error at the point that the new MySQL tables were created.

"An error occured while executing the SQL statement. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=InnoDB' at line 30."

this is the error i get.

when i monify the sql statement from "ENGINE=InnoDB" to "TYPE=MyISAM" and then submit the statement via phpMyAdmin's SQL tool, it works fine.

I can not find anywhere in the migration tool to be able to modify this last line of the statement.

any ideas?

Billy

Migration TOol Kit 1.0.21rc
MySql 4.1
Access version 2000

more info: error

Creating table tblSchool ...
CREATE TABLE `FBRecruit00402_be`.`tblSchool` (
`SchoolID` INT(10) NOT NULL,
`ETSNumber` INT(10) NULL,
`SchoolName` VARCHAR(30) NULL,
`SchoolType` VARCHAR(50) NULL,
`SchoolAddress` VARCHAR(40) NULL,
`SchoolCity` VARCHAR(20) NULL,
`SchoolState` VARCHAR(2) NULL,
`SchoolZip` INT(10) NULL,
`SchoolZipP4` SMALLINT(5) NULL,
`Classification` VARCHAR(6) NULL,
`SchoolPhone` VARCHAR(15) NULL,
`SchoolFax` VARCHAR(15) NULL,
`OfficePhone` VARCHAR(15) NULL,
`SchoolExt` VARCHAR(6) NULL,
`CoachLast` VARCHAR(20) NULL,
`CoachFirst` VARCHAR(20) NULL,
`CoachHomePhone` VARCHAR(15) NULL,
`CoachCellPhone` VARCHAR(15) NULL,
`CoachEMail` VARCHAR(50) NULL,
`CoachAlmaMater` VARCHAR(20) NULL,
`TimeToCall` VARCHAR(25) NULL,
`SchRC` VARCHAR(50) NULL,
`SchComments` LONGTEXT NULL,
`SchOffArea` TINYINT(1) NOT NULL,
`CoachRecRet` DATETIME NULL,
PRIMARY KEY (`SchoolID`),
INDEX `txtCoachID` (`SchoolID`)
)
ENGINE = InnoDB
An error occured while executing the SQL statement.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL serve
r version for the right syntax to use near 'ENGINE = InnoDB' at line 30



Edited 3 time(s). Last edit at 01/09/2006 11:56AM by Billy Fogo.