Importing posts from old website to new conflicting post ID’s?

I can confirm that the imported post will get a new unique ID if (and only if) there already is an existing/conflicting ID in the target database.

Given a post to be imported with an ID of 7579 (represented in the WXR export file as <wp:post_id>7579</wp:post_id>) and an existing post with that exact same ID already in the target database, the generated ID for the imported post was 7583.

(As far why 7583? I would have thought auto increment but 7579 was an existing post, 7580 a revision of that post and 7581 a draft of some sort. So not exactly sure why 7582 was skipped.)

Related Posts:

  1. Why is my database import losing text widget data?
  2. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  3. What’s the database relationship between a post and its attachments
  4. Export WP database for import using WP-CLI on Vagrant Box
  5. When importing database, it shows error
  6. Is a direct or import approach safer for migration into WordPress?
  7. MySQL Syntax Error upon restoring database from backup [closed]
  8. Import live site to local setup without access to live site
  9. Error establishing a database connection; After importing DB & Theme
  10. WordPress database import: Row size too large
  11. Export / import WordPress database
  12. Merging two databases without borking it
  13. Importing CSV into database table not working?
  14. Import users from old WP site to new one
  15. Connection refused on locahost after importing database?
  16. Importing Direct to DB – GUID Question
  17. Best practice to import user base (subscribers) from one website to another?
  18. Importer fails to import every post
  19. WordPress database products structure
  20. Is it good practice to import/export a blog to test a redesign?
  21. How can I query the db to access current post information?
  22. Featured image from custom to WordPress database
  23. Get id from database
  24. I broke database after reuploading local version – what exactly happened? Database error
  25. Using class id from array for query
  26. Create hundreds of users with just ID in phpMyAdmin
  27. Importing Concrete5 content to WordPress
  28. How is better to store at DB 1-side relationsip from CPT to many Taxonomies Terms ID’s?
  29. large number (bigint) for post ID issue in database
  30. Problem while importing a site in WPLocal: SQL files fail to import
  31. What is an ORM, how does it work, and how should I use one? [closed]
  32. What is the difference between an ORM and an ODM?
  33. What is this JavaScript “require”?
  34. Rename a table in MySQL
  35. How should I tackle –secure-file-priv in MySQL?
  36. What is this JavaScript “require”?
  37. What is “Advanced” SQL?
  38. What’s the difference between identifying and non-identifying relationships?
  39. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  40. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  41. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  42. What are the differences between B trees and B+ trees?
  43. MySQL SELECT increment counter
  44. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  45. Example of a strong and weak entity types
  46. Oracle SQL query for Date format
  47. phpMyAdmin – Error > Incorrect format parameter?
  48. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  49. Difference between partition key, composite key and clustering key in Cassandra?
  50. How SID is different from Service name in Oracle tnsnames.ora
  51. What is a relation in database terminology?
  52. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  53. Database vs File system storage
  54. Can I have multiple primary keys in a single table?
  55. Exclude Statement in SQL
  56. How do you query for “is not null” in Mongo?
  57. What is a file based database?
  58. Is it fine to have foreign key as primary key?
  59. Storing Images in DB – Yea or Nay?
  60. Using wpdb to connect to a separate database
  61. how to Optimize WordPress database for 10 million post? [duplicate]
  62. MySQL Database User: Which Privileges are needed?
  63. Database synchronization between dev/staging and production
  64. Keeping WP database synced across multiple developers using git
  65. WPDB Insert or if exists Update
  66. Multiple developers / editors working on a site in progress
  67. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  68. get_results using wpdb
  69. Will it break my site if I delete all transient records in wp_options table?
  70. Checking if Database Table exists
  71. Why WordPress choose data serialization over json_encode?
  72. What’s the simplest way to backup my WordPress database?
  73. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  74. $wpdb won’t insert NULL into table column
  75. Relaunch 4.2 utf8mb4 database upgrade
  76. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  77. Safest way to bulk delete post revisions
  78. Please explain how WordPress works with MySQL character set and collation at a low level
  79. Solution for database version control and deployment?
  80. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  81. How many users can WordPress handle?
  82. Get error messages when $wpdb->insert() returns false?
  83. Detecting errors generated by $wpdb->get_results()
  84. Staging sites, how do you manage synchronising updates in the DB?
  85. Does dbDelta delete columns as well?
  86. How to get the post publish date outside the loop?
  87. MariaDB as a backend database
  88. wpdb update add current timestamp not working
  89. Site stuck in “Database Update Required” loop
  90. How to fetch Data in WordPress using MySQLi or $wpdb
  91. WordPress Database lost auto increment
  92. Count & Display Database Queries
  93. Connect to database using wordpress wp-config file
  94. How can I make a WordPress database portable and url independent?
  95. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  96. wpdb->insert multiple record at once
  97. How to migrate a HTTPS WordPress installation to localhost?
  98. Two WordPress sites sharing the same content
  99. How to integrate custom database table in WordPress and using WordPress functions
  100. Reset Post IDs to less than 64bit integer

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)