Hi Guys,

I have an existing MySQL 3 database. I want to create a new one with the same tables in MySQL 5. I have extracted all the create table statements. Take this one for example:

Code:
DROP TABLE IF EXISTS `terms`;
CREATE TABLE `terms` (
  `TermID` int(11) NOT NULL auto_increment,
  `Year` int(11) default '0',
  `Quarter` int(11) default '0',
  `Starts` varchar(10) default NULL,
  `Ends` varchar(10) default NULL,
  `Seq` int(11) NOT NULL default '0',
  PRIMARY KEY  (`TermID`),
  KEY `TermID` (`TermID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
and I have changed Engine = MyISAM to Engine = InnoDb as follows:

Code:
DROP TABLE IF EXISTS `terms`;
CREATE TABLE `terms` (
  `TermID` int(11) NOT NULL auto_increment,
  `Year` int(11) default '0',
  `Quarter` int(11) default '0',
  `Starts` varchar(10) default NULL,
  `Ends` varchar(10) default NULL,
  `Seq` int(11) NOT NULL default '0',
  PRIMARY KEY  (`TermID`),
  KEY `TermID` (`TermID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
Is this a valid method or will I have problems