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. Database vs File system storage
  31. $wpdb won’t insert NULL into table column
  32. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  33. WP Multisite: load content from site X on site Y
  34. What is the purpose of the option name hack_file in the options table?
  35. WordPress Connection Pooling
  36. Improve or optimize a very slow query
  37. What is the advantage of separating wp_users and wp_usermeta table?
  38. “MySQL server has gone away” since update to 3.8
  39. WordPress page title repeated in SOME pages
  40. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  41. How to correctly add a table to the WordPress MySQL database
  42. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  43. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  44. Merge two databases: OLD SITE -> NEW SITE
  45. Is it safe to convert tables from MyISAM to InnoDB?
  46. Use one WordPress database with multiple instances of one site
  47. Who is responsible for data sanitization in WordPress development?
  48. How do I properly update the WordPress database password?
  49. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  50. $wpdb->insert is not working
  51. WordPress Install and Database on separate hosting?
  52. Moving a site from a temporary domain to the live domain [duplicate]
  53. I need to get an array from the wordpress database
  54. Moving minor updates between local and live sites – just database?
  55. what is the best way to store user created data?
  56. WP get stuck with a query on MySQL when the site is resumed
  57. Using GROUP CONCAT in my-sql query with wp_usermeta table
  58. How to move the WordPress site Layout from test site to Production site?
  59. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  60. Retrieve data from the database to table such as comments in the admin control panel
  61. Need to store custom user information (many-many relationsips), preferably not as user meta
  62. charset problem with new custom table
  63. import posts with dutch/special letters
  64. WordPress and user security
  65. How to share plugin created database tables between two WordPress sites
  66. How to connect to a remote database in WordPress?
  67. Moving to another server database connection error [closed]
  68. Best practice to limit results in get_row()?
  69. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  70. Connect to another WP install and grab post based on custom field
  71. Which table (and column) has the content of configured get_post_meta?
  72. Serialize data before inserting into the DB
  73. Reinstalling wordpress from database breaks the site
  74. Pages from custom table
  75. Trouble running $wpdb->query() with last_insert_id
  76. Can I customised default WP table
  77. Woocommerce – Check product stock availability from external database
  78. WordPress where clauses in db select
  79. How to display data from db in select list [closed]
  80. Will adding & modifying default WordPress table index break future WordPress update
  81. Database migration issues – Error #1046 No database selected
  82. echo site_url() returns a different value than what is in the database siteurl field
  83. Native timestamp on wp_options option
  84. SELECT rows between two datetimes when the range is dynamic [closed]
  85. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  86. How to access a table in a wordpress database using REST API?
  87. error establishing a database connection 3
  88. Correct and secure way to access a custom SQL database in a custom PHP template file
  89. Does WordPress Support Using Named Pipes on the Windows Operating System?
  90. Missing latest posts and options after DB migration via phpMyAdmin
  91. Surrogate ID for posts, is there an alternative field in the posts table?
  92. Custom metabox does not store data
  93. How do i get value from wp_postmeta?
  94. Local host to server import problem
  95. “MySQL server has gone away” since update to 3.8
  96. featured image not showing up with mysql_connect
  97. Getting deleted users in database
  98. Options of accessing wordpress data from mobile app
  99. Getting data from a table using a query
  100. Database interaction (private-public) [closed]

Leave a Comment