MysSQL db not restoring

Sorry for the OT post but here goes...

I do nightly dumps of a MySQL database and now I've finally mistakenly
emptied some tables I shouldn't have. I'd like to restore last nights
dump file.

This is the command I'm using:

mysql -u username -ppassword db_name < db_name.dump

I'm getting the following error:

ERROR 1064 at line 118: You have an error in your SQL syntax near
'unique (email)
) TYPE=MyISAM' at line 21


Anyone know why this is going wrong? Am I doing something obviously
wrong?


Chris.
--
Don't like reformatting your Outlook replies? Now there's relief!
http://home.in.tum.de/~jain/software/outlook-quotefix/

* Thus wrote Chris W. Parker (cparker@swatgear.com):
>
> I'm getting the following error:
>
> ERROR 1064 at line 118: You have an error in your SQL syntax near
> 'unique (email)
> ) TYPE=MyISAM' at line 21

You probably have a field name that is a keyword of some sort. Hard
to tell without seeing the create table syntax.


Curt
--
"My PHP key is worn out"

PHP List stats since 1997:
http://zirzow.dyndns.org/html/mlists/