Database Restore Issue

I switched hosts and I am following the tutorials at http://www.tamba2.org.uk to back up and restore my database. I have managed to back up my database fine (I guess). When I go to restore it, I get an error. I’m at the part where I click on the SQL tab and paste the contents of the .sql file or upload it. I tried both methods and I get the same error:

ERROR:
SQL query:

CREATE TABLE wp_categories (
cat_ID int( 4 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) NOT NULL default ”,
category_nicename varchar( 200 ) NOT NULL default ”,
category_description text NOT NULL ,
category_parent int( 4 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
UNIQUE KEY cat_name ( cat_name ) ,
KEY category_nicename ( category_nicename )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2

MySQL said: Documentation
#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=2’ at line 10

Now, I have no clue what any of this stuff means. Any help would be greatly appreciated!

Lindsay