SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]

Your wp_comments table already has a comment with id “1”.

You will need to remove the existing entries.

If you want to keep them, then remove the “id” field from all comments you’re importing.

Related Posts:

  1. Setting up foreign keys in phpMyAdmin?
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL Error #1133 – Can’t find any matching row in the user table
  4. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  5. How to create a foreign key in phpmyadmin
  6. importing a CSV into phpmyadmin
  7. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  8. What specific database privileges does WordPress need?
  9. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  10. How to copy post titles to post slug in phpmyadmin
  11. How to do a MySQL dump from production site without using a search and replace script for local development?
  12. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  13. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  14. Can’t find my wordpress DB in phpmyadmin
  15. Backing up and restoring multiple sites efficiently
  16. $wpdb to insert html form information
  17. Setting up WordPress Locally on WAMP for a new site (with one already)
  18. Getting Error Trying to Create Table
  19. Export Yoast Keywords from MySQL/phpMyAdmin
  20. Editing mysql tables/database with wordpress or other app/cms
  21. List users with the most posts in the last 30 days
  22. Export SQL query based on custom field?
  23. Mysql Server keeps crashing
  24. How to bulk delete a certain part of all wordpress posts
  25. When I add metadata, metavalue length is added in to the value in some cases
  26. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  27. Find locations of all featured images of draft posts via SQL
  28. SQL query to change custom field in WordPress database
  29. An SQL query to find orphaned image attachments and their meta
  30. cannot log in to the mysql server (wamp and wordpress)
  31. SQL command to export post_content from wp_posts using phpMyAdmin
  32. Need SQL query to find&replace image URL
  33. Column count doesn’t match value count at row 1
  34. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  35. MySQL string replace
  36. Which MySQL data type to use for storing boolean values
  37. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  38. Cannot delete or update a parent row: a foreign key constraint fails
  39. Your password does not satisfy the current policy requirements
  40. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  41. What is the definition of cardinality in SQL
  42. How to restart remote MySQL server running on Ubuntu linux?
  43. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  44. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  45. Selecting data from two different tables without using joins
  46. Difference between VARCHAR and TEXT in MySQL
  47. MySQL: Invalid use of group function
  48. Simple Random Samples from a Sql database
  49. What does SQL clause “GROUP BY 1” mean?
  50. LAST_INSERT_ID() MySQL
  51. SQL select only rows with max value on a column
  52. Trying to perform MINUS operation in MySQL
  53. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  54. MySQL config file location – redhat linux server
  55. Create boolean column in MySQL with false as default value?
  56. Is there a naming convention for MySQL?
  57. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  58. MySql – HAVING vs WHERE 
  59. GROUP_CONCAT comma separator – MySQL
  60. Set page template for all pages?
  61. Optimize Multiple Taxonomy Term MySQL Query?
  62. Using source control with WordPress
  63. My WordPress site always displays a cached version of its homepage
  64. wpdb prepare syntax
  65. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  66. How to run this SQL query of wp_terms database
  67. Proper way to work with wpdb to get user’s firstname
  68. How to change post format from Aside to Image for all posts?
  69. Inserting Hundreds of Thousands of Posts at Once
  70. wp_admin edit.php slow with lots of queries
  71. How to add and SQL query of posts only published
  72. Slow Mysql Queries
  73. Find duplicate posts with same slug and author
  74. Migrating from Existing MySQL Setup to WordPress
  75. How to split the a table in database?
  76. How do I join a $wpdb query with user meta using default value if not exist?
  77. mySQL statment count of post in each category and sub category
  78. Paypal Post IPN handeling nightmare
  79. Is there a page length limit?
  80. What’s the sql for this condition?
  81. Create a form with custom autocomplete address field and CSV import values
  82. WordPress insert query is not working : Showing no Error
  83. Copy usermeta value where ID matches in the same table
  84. Some Post Content Does Not Show Up In DB Search
  85. How can I view my site directly from WordPress dashboard?
  86. (WP List Table) How to sort by SKU and Custom Fields?
  87. Word Press and database from another server sync
  88. User set date and time from frontend doesn’t get stored into database
  89. get posts whether meta_key exists or not
  90. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  91. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  92. update_option returns false in AJAX, how to debug?
  93. WordPress database error Duplicate entry for key ‘slug’
  94. MySQL – How to combine data from two tables into one?
  95. Check if a database is well installed
  96. Stop my loop to register data twice
  97. `#1215 – Cannot add foreign key constraint
  98. How to restore: Database intact but folders deleted
  99. XML RPC post produces immediate revision with odd post_date_gmt
  100. SQL Database Lost