#1062 - 键 'PRIMARY' 的重复条目 '1'

我在这里完全不知所措.我有两个数据库.一个在我用于开发的 localhost 站点上，另一个在我的远程站点上用于我的实时(生产)站点.我通过 phpMyadmin 管理它们.正如我几个月来一直在做的那样，当我需要更新实时站点时，我会转储相关数据库并从我的本地主机站点导入数据库.

I am at a complete loss here. I have two databases. One on my localhost site that I use for development and one on my remote site that I use for my live (production) site. I manage both of them through phpMyadmin. As I have been doing for months now, when I need to update the live site, I dump the related database and import the database from my localhost site.

现在，无论我尝试什么，我总是收到此错误:

Now, no matter what I try, I keep getting this error:

错误SQL查询:

--
-- Dumping data for table `oc_address_type`
--
INSERT INTO  `oc_address_type` (  `address_type_id` ,  `address_type_name` ) 
VALUES ( 1,  'Billing' ) , ( 2,  'Shipping' ) ;

MySQL 说:文档

#1062 - 键PRIMARY"的重复条目1"

#1062 - Duplicate entry '1' for key 'PRIMARY'

我尝试在我的本地主机上创建一个新的空白数据库并将其导入但结果相同.我已经验证了所有的表和索引，并没有发现任何错误.

I tried creating a new blank database on my localhost and importing into that but same results. I have validated all of the tables and indexes and cannot find anything wrong there.

请提出任何建议，因为在此问题得到解决之前，我已经完全崩溃了.

Any suggestions please as I am completely down until this gets resolved.

顺便说一下，我完全删除了所有表并导入结构和数据.这一直有效，直到今天.

By the way, I am completely dropping all tables and importing structure and data. This has always worked until today.