My local webserver died so I rebuilt it. The production webserver I'm using runs Mysql 3.23. My local server runs 5.0. If I take my dumped sql db from the webserver & try to load it on the local server, I get:
mysql db < Fri.db-backup.sql
ERROR 1060 (42S21) at line 97350: Duplicate column name 'address_types_id'
the area in question looks like:
# head -n 97355 Fri.db-backup.sql | tail -n 10
-- Table structure for table 'address_types'
CREATE TABLE address_types (
address_types_id int(4) NOT NULL auto_increment,
address_types_description varchar(25) default NULL,
address_types_abrv char(3) default NULL,
PRIMARY KEY (address_types_id,address_types_id)
any idea how I can fix this?