problem with importing database from laptop to server, getting error!

[spewn]

i am transferring my database to the server via phpmyadmin...i went to export and can see my tables in phpmyadmin, yet there is an error:

CREATE TABLE `offers` (

`offerID` int( 4 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`offerName` varchar( 100 ) NOT NULL default '',
`offerName2` varchar( 100 ) NOT NULL default '',
`offerType1` varchar( 100 ) NOT NULL default '',
`offerType2` text NOT NULL ,
`offerLink` text NOT NULL ,
`offerImgSmall` text NOT NULL ,
`bannerImg` text NOT NULL ,
`rightNavImg` text NOT NULL ,
`offerPitch` text NOT NULL ,
`offerTitle` text NOT NULL ,
PRIMARY KEY ( `offerID` ) 
) ENGINE = MYISAM DEFAULT CHARSET = latin1 
MySQL said:  

#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 'DEFAULT CHARSET=latin1' at line 14

any ideas? i am running 4.1, and the server might be 4.0, but i don't want that to taint your response...what do i need to do here?

- g

 

[LTeeple]

Maybe you need a comma between MYISAM and DEFAULT?

CREATE TABLE `offers` (

`offerID` int( 4 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`offerName` varchar( 100 ) NOT NULL default '',
`offerName2` varchar( 100 ) NOT NULL default '',
`offerType1` varchar( 100 ) NOT NULL default '',
`offerType2` text NOT NULL ,
`offerLink` text NOT NULL ,
`offerImgSmall` text NOT NULL ,
`bannerImg` text NOT NULL ,
`rightNavImg` text NOT NULL ,
`offerPitch` text NOT NULL ,
`offerTitle` text NOT NULL ,
PRIMARY KEY ( `offerID` ) 
) ENGINE = MYISAM, DEFAULT CHARSET = latin1

Cheers!
Laura