Moving databases, different SQL version - wordpress

I've read every single post at wordpress.org support and none of them helped. I moved servers and need to move my DB froma mySQL version 2.6.4-pl2 to a version 2.6.0-pl3.

Code: 
Error

SQL-query:

CREATE TABLE `wp_categories` (
`cat_ID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`cat_name` varchar( 55 ) NOT NULL default '',
`category_nicename` varchar( 200 ) NOT NULL default '',
`category_description` longtext NOT NULL ,
`category_parent` int( 4 ) NOT NULL default '0',
PRIMARY KEY ( `cat_ID` ) ,
KEY `category_nicename` ( `category_nicename` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =6

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ' at line 9
Just about every "solution" I've read involved removing "DEFAULT CHARSET=latin1" or some part of that line.. but that just gives me the same error minus "DEFAULT CHARSET=latin1"

Any help is much appreciated, I can send the sql file

thanks!

 

 

 

 

Top