importing database into new server mysql ERROR

im finally moving my blog from localhost to a more prominent location—online. When attempting to import the database, this problem occured:

“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 AUTO_INCREMENT=5’ at line 10 “

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 bigint( 20 ) NOT NULL default ‘0’,
category_count bigint( 20 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
KEY category_nicename ( category_nicename )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =5

so what should i do? p.s. this might help, to be sure that the file isnt corrupted, i uploaded it to my localhost database and it worked perfectly.