Switching Servers, Database Import Problems, Help Appreciated

I'm on the newbie side when I veer from SEO and SEM, so please lend me a hand.

I used phpmyadmin to dump and import and this is the error I'm getting:

"#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 '`application_mode_id` int(1) NOT NULL auto_increment,
`application_mode` varch' at line 1 "

Here is the code at the beginning of the db, where I'm assuming the problem is...

CREATE TABLE `application_mode` (
  `application_mode_id` int(1) NOT NULL auto_increment,
  `application_mode` varchar(50) default NULL,
  PRIMARY KEY  (`application_mode_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

Code (markup):

Cheers.

 

Are you using a different MySQL version?

 

Yeah, from 2.6.0 to 5.0.45...