Problem loading a new DB from a dump script

[Steven Rix]

I'm trying to populate a new copy of my database from the dump script taken from an overnight backup. It starts out OK but then errors with: ERROR 1060 (42S21) at line nnn: Duplicate column name 'id'.

Taking a look at the script I can see that the previous couple of tables have loaded without problem but the offending CREATE TABLE looks like this:

CREATE TABLE xxx (id int(11) NOT NULL auto_increment, <other columns...> ,PRIMARY KEY (id,id)) ...

The id column is only defined once but is duplicated in the PRIMARY KEY definition - strange! Looking through the script I see this is the case on some of the other CREATE TABLE statements also.

Any ideas?

Many thanks,

Steve Rix