Uploading MySql Database to Hosting Server

Hello,

I purchased the Database Starter Kit fof PHP and the UserRegistration Solution Pack and am in the process of practicing uploading my MySQL Database to my Hosting Server.

I have a problem I just can not figure out how to fix. I hope you all will have some pointers to get me on the right track. I am using the PHP Database just as it came to me with the except that I import the User Registration Table.

MySQL Server Side Version - 5.0.25
myphpmyAdmin version - 2.11.9.4

I checked the error log and could not find a solution to this problem.

Once I export out of "MySQL Administrator" and try to import into MyphpMyAdmin I keep getting the following error message.


Error
SQL query:

CREATE TABLE `countries` (

`CountryID` int( 10 ) unsigned zerofill NOT NULL AUTO_INCREMENT COMMENT 'Primary key for Countries table',
`CountryName` varchar( 50 ) COLLATE latin1_bin DEFAULT NULL COMMENT 'Name of country',
`CountryAbbrev` varchar( 50 ) COLLATE latin1_bin DEFAULT NULL COMMENT 'Abbreviation of country',
PRIMARY KEY ( `CountryID` ) USING BTREE,
KEY `CountryID` ( `CountryID` )
) ENGINE = InnoDB AUTO_INCREMENT =4 DEFAULT CHARSET = latin1 COLLATE = latin1_bin;


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 'COLLATE latin1_bin DEFAULT NULL COMMENT 'Name of country',
`C
-------------------
Sheila
donegan@iinet.com