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. Difference between partition key, composite key and clustering key in Cassandra?
  29. How SID is different from Service name in Oracle tnsnames.ora
  30. What is a relation in database terminology?
  31. Why WordPress choose data serialization over json_encode?
  32. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  33. Reset Post IDs to less than 64bit integer
  34. how can get database name in wordpress?
  35. Does WordPress use the InnoDB engine for MySQL by default?
  36. Best way to import users, post and categories from an external database
  37. Performance tips for a large user base [closed]
  38. Inserting Post Meta From SQL
  39. Saving Metadata from the Gutenberg Editor Sidebar to the Database
  40. Migrate a Non WordPress database to wordpress [closed]
  41. Moving an entire wordpress site from one domain to a new domain and database
  42. Copy customizer options to child theme
  43. Custom DB_COLLATE (collation) value not working on fresh install?
  44. What causes the “max_user_connections” warning on WordPress frontend?
  45. How to use user table of a different database for WordPress users?
  46. Subscribers to posts
  47. $wpdb->update has finished saving trigger?
  48. Getting all the users who have author privilege
  49. For WordPress is there content in the database which I can safely ignore?
  50. How can I UN-orphan media files?
  51. WordPress choose wrong database
  52. Sync user meta data to a second database
  53. Is it safe to delete unnecessary user metadata?
  54. WordPress Relational Database
  55. wp-cli search is returning ‘search’ is not a registered subcommand of ‘db’
  56. Switching Databases in LocalHost
  57. wp_insert_post causing There was an error connecting to the database: Access denied for user ‘root’@’localhost’ (using password: NO)
  58. How to update the values when the featured image has changed?
  59. Does WordPress $wpdb functions wait when table is locked?
  60. Unable to set a default serialized array using dbdelta()
  61. Importing 10 Years of Media into the WP Database
  62. 2 WordPress sites with 2 databases but sharing the same users
  63. Insert Query not working in the form
  64. connecting to DB from custom php file
  65. Make changes of wp-db.php file persistent against updates
  66. Change the default data installed when setting up WordPress
  67. Clear Terms from Taxonomy for Specific Post IDs?
  68. WordPress security [closed]
  69. How to split the WordPress database?
  70. $wpdb->get_var – What value is returned when zero records are found?
  71. SymmetricDS in dev + prod workflow?
  72. Fixing YARPP plugin FULLTEXT MySQL indexing
  73. Advantages of dbDelta
  74. Only allow user to access a link once a year, based on their joining date
  75. Error establishing a database connection in wordpress site , website not opening
  76. wpdb Insert unknown post data dynamic foreach loop
  77. How do I use a database in a custom theme?
  78. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  79. Migrating meta_key and meta_value from old theme to new one
  80. How do you enable scripts on a WordPress installation in Softaculous?
  81. How to rerieve comments and their replies from DB
  82. Inserting data with Geometry field
  83. I Want a More Concice Form of Data than an Array
  84. Export only a part of the database for migration
  85. Duplicate database to roll back theme & content changes
  86. database error WordPress move from one hosting to other
  87. Select data from foreach loop and send it to wordpress database
  88. Error establishing database connection error during first WordPress run
  89. Same DB for live and dev versions
  90. update multiple user meta field based on another meta field
  91. execute custom function on database connection error
  92. version control for wordpress? (wordpress folder and database at same time)
  93. not saving post in wp_post wordpress database table
  94. Install WordPress with SQL database
  95. How to back-up a database on IIS
  96. Creating Job Tickets
  97. Best db table structure for users with many records
  98. Where are database files of a WordPress website?
  99. Set a minimal number for next user_id
  100. Query a meta key using an array of values where the database value is a string

Leave a Comment