Error importing from v 2.8 to 2.10

[thefreebielife]

-- 
-- Table structure for table `gifts`
-- 

CREATE TABLE `gifts` (
  `gId` int(6) NOT NULL auto_increment,
  `gName` text NOT NULL,
  `gDescription` text NOT NULL,
  `gImage` text NOT NULL,
  `gRef` int(4) NOT NULL default '0',
  `gPrice` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `iplogs`
-- 

CREATE TABLE `iplogs` (
  `iid` int(6) NOT NULL auto_increment,
  `iusername` text NOT NULL,
  `idate` text NOT NULL,
  `iip` text NOT NULL,
  `logins` text NOT NULL,
  PRIMARY KEY  (`iid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `mcredit`
-- 

CREATE TABLE `mcredit` (
  `mCreditId` int(10) unsigned NOT NULL auto_increment,
  `dateCompOffer` datetime NOT NULL default '0000-00-00 00:00:00',
  `email` text NOT NULL,
  `status` varchar(45) NOT NULL default '',
  `username` varchar(45) NOT NULL default '',
  `offername` text NOT NULL,
  PRIMARY KEY  (`mCreditId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `messages`
-- 

CREATE TABLE `messages` (
  `messId` int(10) unsigned NOT NULL auto_increment,
  `fromUser` varchar(45) NOT NULL default '',
  `toUser` varchar(45) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `messDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `messStatus` varchar(45) NOT NULL default '',
  `txtSubject` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`messId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `news`
-- 

CREATE TABLE `news` (
  `newsID` int(10) unsigned NOT NULL auto_increment,
  `ndate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `nuser` text NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`newsID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `offers`
-- 

CREATE TABLE `offers` (
  `oId` int(6) NOT NULL auto_increment,
  `oCampID` int(11) NOT NULL default '0',
  `oaffiliate` text NOT NULL,
  `oCost` text NOT NULL,
  `oName` text NOT NULL,
  `oDescription` text NOT NULL,
  `oLink` text NOT NULL,
  `oImage` text NOT NULL,
  `oInstructions` text NOT NULL,
  `oWait` text NOT NULL,
  `oweight` text NOT NULL,
  `ocountry` text NOT NULL,
  PRIMARY KEY  (`oId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `offerscompleted`
-- 

CREATE TABLE `offerscompleted` (
  `uId` int(10) unsigned default '0',
  `oName` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00'
) 

-- --------------------------------------------------------

-- 
-- Table structure for table `orders`
-- 

CREATE TABLE `orders` (
  `id` int(6) NOT NULL auto_increment,
  `ousername` text NOT NULL,
  `ofname` text NOT NULL,
  `oaddress` text NOT NULL,
  `ocity` text NOT NULL,
  `ostate` text NOT NULL,
  `ozip` text NOT NULL,
  `date` text NOT NULL,
  `ostatus` text NOT NULL,
  `ogiftname` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `paypaldetail`
-- 

CREATE TABLE `paypaldetail` (
  `username` varchar(45) default '',
  `paypalId` varchar(45) default ''
)

-- --------------------------------------------------------

-- 
-- Table structure for table `spamreport`
-- 

CREATE TABLE `spamreport` (
  `username` varchar(45) NOT NULL default '',
  `reportedBy` varchar(45) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`username`)
) 

-- --------------------------------------------------------

-- 
-- Table structure for table `ticket_replies`
-- 

CREATE TABLE `ticket_replies` (
  `trid` int(6) NOT NULL auto_increment,
  `tid` text NOT NULL,
  `tusername` text NOT NULL,
  `tfrom` text NOT NULL,
  `tto` text NOT NULL,
  `trproblem` text NOT NULL,
  PRIMARY KEY  (`trid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `tickets`
-- 

CREATE TABLE `tickets` (
  `tid` int(6) NOT NULL auto_increment,
  `tusername` text NOT NULL,
  `tdate` text NOT NULL,
  `tsubject` text NOT NULL,
  `tproblem` text NOT NULL,
  `tstatus` text NOT NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `uId` int(6) NOT NULL auto_increment,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `fname` text NOT NULL,
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `zip` text NOT NULL,
  `country` text NOT NULL,
  `ip` text NOT NULL,
  `gid` int(6) NOT NULL default '0',
  `rid` int(6) NOT NULL default '0',
  `ostatus` double NOT NULL default '0',
  `holdreason` text NOT NULL,
  `astatus` tinyint(4) NOT NULL default '0',
  `date` text NOT NULL,
  `deadline` text NOT NULL,
  `dead` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`uId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

Importing this used to work perfectly on my php admin 2.8 when i did it multiple times, but i recently changed hosts and they have version 2.10 and now i get errors like:

 

#1064 - 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=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCR

[fenway]

Sounds like a mysql server version change...