Error importing database export (transferring to new host)

I followed the instructions on how to export my databases from my old site and now I’m trying to import to my new site using phpMyAdmin. I created the database and tried to import the file but I got the following error:

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 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 =6;

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 ‘ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6’ at line

Any suggestions?