phpmyadmin 错误“#1062 - 密钥 1 的重复条目‘1’"

2022-01-05 00:00:00 database php mysql phpmyadmin mysql-error-1062

我从数据库中删除了所有表，然后恢复(导入)了一个备份.之后我收到 error #1062 - Duplicate entry '1' for key 1.

I dropped all tables from a database then restore(import) a backup. Afterwards I am getting error #1062 - Duplicate entry '1' for key 1.

我应该重复这个过程吗?或者是其他东西?为什么会出现这个错误?

Should i repeat the process. Or something else? Why this error is coming?

推荐答案

当你从 php admin 导出你的 sql 时

When you export your sql from php admin

选择自定义"作为导出方式"

Select "custom" as export method"

然后，选择更新"而不是插入"

then, instead of 'insert', choose "update"

这将执行更新语句并防止重复插入.

This will perform update-statements and prevent duplicated inserts.

相关文章