Importing Posts into New Website with Same User ID’s

Don’t bother with the SQL import, instead use a standard WXR import/export.

The importer will ask you which users map onto which during import, letting you create new users or assign old ones, then update all the authors on import.

For larger imports, use WP CLI for both the import and export. Make sure it chunks the import into files with 250 posts max so that memory doesn’t become an issue, and pass it a text file mapping all the old users to new users.

If you can’t run WP CLI on your server, pull down the site on to a local dev environment, run WP CLI on your machine locally, then do the same for the import, and transfer the database in full to the new remote location

Related Posts:

  1. Combining user database tables while keeping all other data in seperate for multiple sites?
  2. Sharing users across multiple sites, each on their own database
  3. How to share User Database between Two Multisite Installations + More
  4. How to use the same users table on multiple wordpress sites
  5. WordPress automatic Login on other page?
  6. How To Add Custom Form Fields To The User Profile Page?
  7. How can I trust switch_to_blog()?
  8. Why are my roles not visible in a Multi-site/Network?
  9. How to use same email for multiple users
  10. Where can I find documentation on what characters are allowed in user names and why?
  11. Add WordPress MU Network Admin via Database
  12. How to tell which database tables belongs to which multisite site
  13. wordpress multisite, how to keep user on subdomain throughout registration process?
  14. WordPress Multisite – When a user signs-up on main site, how to add the user to a subsite
  15. How to use alias domain for multisite installation?
  16. Shared table across network
  17. Different back-end colour scheme for the different sites of a multisite
  18. Set up collaborative site
  19. Multisite: How to store global options vs. site options?
  20. Uploading/Deploying a Multi Site Install
  21. Multisite database upgrade SSL error
  22. Configure WordPress to read from database only, never write
  23. How does WordPress connect sites and the wp_users table?
  24. Prevent user creating new users with specific roles
  25. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  26. Migrating WPMS from apache to IIS7 causes Database Error
  27. How to add multiple existing users to a multisite site?
  28. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  29. Why can’t I delete original user in multisite? Options for manual removal
  30. How to add edit users capability to a custom role?
  31. How to change the database prefix in multisite (WPMU) install
  32. WPMU – new users are automatically subscribed to the main blog – how to prevent that?
  33. In MultiSite, can some users automatically have Site Admin rights on all sites, without granting them Network Admin access?
  34. Multisite setup creating custom table
  35. Is there a way to run upgrade.php for one blog?
  36. Bulk activate a theme on multisite
  37. Assign role to user on first login, if they are first (after admin)
  38. Migrating Multisite – Database error, missing wp_blogs table
  39. Make a user administrator to a sub directory site and a contributor to main site in multisite network
  40. How to store custom user data on the database?
  41. Query users by capability – uninstall/deactivate callback
  42. How to change user starting role in WordPress MultiSite?
  43. Multisite – One user allowed access to all sites?
  44. How do you disable account activation in WPMU and then log the user in right away?
  45. WordPress Multisite – can I somehow merge the tables?
  46. Four columns in the wp_users table
  47. Multisite with subfolders- can’t access main site- Error establishing a database connection
  48. Use WordPress MultiSite (WPMS) with a remote database for each created site
  49. WordPress Multisite blogs not working after domain swap
  50. Least expensive way to get table prefix in multisite installation
  51. Create Custom Multisite User Role to Reduce Capabilities
  52. Obtaining user table for one site on multisite set up
  53. how to migrate wpmu from one host to the other?
  54. How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
  55. Get users registered 30 days ago(or more)
  56. Bulk Move Users from one site to another within a network ( Multisite )
  57. WordPress Multisite – Load users using custom query
  58. How can I create blog specific database table in multisite?
  59. Copy user role on multisite so the user can access subsites with same role
  60. How To Disable Add new users On Subsites In Multisite?
  61. $wpdb->update prefixes database name to table when executing query
  62. Wait ajax to complete before continue loop
  63. WP MultiSite: Can’t select database error after changing to new domain
  64. How to fix that new users show up again in subsite of a Multisite?
  65. How to delete user from MU site when the user is removed from their site?
  66. Customize or avoid new admin email address notification
  67. Using Same User Database on Subdomain
  68. How to get the blogs owned by a user?
  69. How long is “as long as possible” in wp_cache_set()?
  70. How to redirect user after session timeout
  71. Questions about MU database schema and how to list all blogs
  72. can’t create user without email for an author after converting single site to multisite
  73. “My Sites” incorrectly showing all network sites for all logged in users
  74. A database for each category?
  75. Problems with WordPress multisite directories/url structures and admin access after migration
  76. allow multisite in the installation process
  77. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  78. Will resetting my database affect other sites on my multisite WordPress install?
  79. WordPress Database Cleanup
  80. Modify new user email notification in network admin screen wp multisite
  81. Optimal setup for Multi Domain WordPress with Woocommerce
  82. Can’t activate a user on multisite install
  83. A different role for each site in a multisite
  84. Get multisite count without php?
  85. Problem in adding new site on WP multisite
  86. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  87. Get current user outside of WordPress Multisite
  88. How to create child/sub user under parent user
  89. WordPress MU users – how are they organized?
  90. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  91. Plugin data shared in Multisite
  92. Is there any way to give all users access to one blog in a multisite network without using a plugin?
  93. Merging versions of wp_posts based on post_title
  94. WordPress multisite and one database
  95. Redirect authors from upload.php url to Home page in Multisite
  96. WordPress Multisite platform for different city for single db
  97. Using a number for limiting registering or banning on multisite
  98. Unsure of my options, Multi-blog?
  99. WordPress Multisite (Network) some site users added to main site users list as subscriber
  100. HyperDB, Multisite – on new site creation put site’s tables to specific database