MySQL Restore Difficulties — error in SQL syntax

I’ve been obliged to restore a WordPress installation from a dump. The data originally came from MySQL v4.1.20. When I reinstalled MySQL I used 4.1.22.

Anyway, I created the database and tried used the following command to reload the data:

mysql -u root -p databasname < /path/to/databasename which results in MySQL making the following complaint,

“ERROR 1064 (42000) at line 133: 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 ‘-commerce char(1) NOT NULL default ”,
wp-user char(1) NOT NULL default ”,
‘ at line 9″

I’m not a mysql programmer so this error falls on blind eyes. I gather this is a “parse error” but I’m not at all sure how to fix this. Any help would be appreciated.

Here’s the SQL,

CREATE TABLE bjcwp_comms (
id bigint(20) unsigned NOT NULL auto_increment,
email varchar(255) NOT NULL default ”,
mobile varchar(64) NOT NULL default ”,
name varchar(255) NOT NULL default ”,
title varchar(255) NOT NULL default ”,
organisation text NOT NULL,
subscribed char(1) NOT NULL default ”,
wp-user char(1) NOT NULL default ”,
wp-user-id bigint(20) unsigned default NULL,
time datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (id),
KEY subscribed (subscribed)
) TYPE=MyISAM;