customers sql

[bluezdaze]

Hi - I think I am posting this in the wrong place, but couldn't seem to find a better one.

I need to edit and make changes to the customers.sql, so before I did anything I exported it and imported it without making any changes, just to be sure it would import. Well, without making any changes at all, I got the following error (I replaced personal info with XXXX):

SQL query:
-- -- Dumping data for table `customers` -- INSERT INTO `customers` (`customers_id`, `purchased_without_account`, `customers_gender`, `customers_firstname`, `customers_lastname`, `customers_dob`, `customers_email_address`, `customers_default_address_id`, `customers_telephone`, `customers_fax`, `customers_password`, `customers_newsletter`, `guest_account`, `customers_login`, `customers_group_name`, `customers_group_id`, `customers_group_ra`, `customers_payment_allowed`, `customers_shipment_allowed`) VALUES (2, 0, '', 'XXXX', 'XXXX', '0000-00-00 00:00:00', 'XXX@XXX.com', 2, '702.275.7531', '', 'e42c94ee12a985cd3e9842a6bc61b9d7:d9', '0', 0, NULL, 'Retail', 0, '0', '', ''), (97, 0, '', 'XXXX', 'XXXX', '0000-00-00 00:00:00', 'XXXX@XXXXX.com', 113, '209-495-0687', '', '063e4d336e3104a341b4c07a50a7fc09:f6', '0', 0, NULL, 'Retail', 0, '0', '', ''), (27, 0, '', 'XXXX', 'XXXX', '0000-00-00 00:00:00', 'XXXX@XXXX.com', 31, '571-294-6953', '', 'e073aa33a[...]
MySQL said:
#1062 - Duplicate entry '2' for key 1

I'm not sure how I can get an error without making any changes to it.
Thanks for any help.

[michael_s]

In order to import, you first have to empty the customers table of all data. You see, you are trying to insert customers_id #2 into a table that already has a customers_id #2.

customers_id is the primary key on the table, so you can't import more than one customer record with the customer_id of 2. They all must be unique.

[bluezdaze]

Thanks Michael - makes sense now!