phpmyadmin error "#1062 - Duplicate entry '1' for key 1"

php mysql database phpmyadmin mysql-error-1062
Jitendra Vyas picture Jitendra Vyas · Jul 19, 2010 · Viewed 55.1k times · Source

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?

Answer

Gary Tsui picture Gary Tsui · Aug 28, 2013

When you export your sql from php admin

enter image description here

Select "custom" as export method"

enter image description here

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

This will perform update-statements and prevent duplicated inserts.

Related questions

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
Update query PHP MySQL

Can anybody help me understand why this update query isn't updating the fields in my database? I have this in my php page to retrieve the current values from the database: <?php $query = mysql_query ("SELECT * FROM blogEntry WHERE …

Read More
MySQL Workbench vs phpMyAdmin

I've only used phpMyAdmin but then I stumbled upon MySQL Workbench that looks promising. I wonder if someone has tried it out and could give your thoughts about it compared to phpMyAdmin. Could it replace phpMyAdmin completely?

Read More