Import users from old WP site to new one

Changing the user IDs could be problematic. Other tables reference those – including wp_usermeta but if they are authors, customers, etc. then any tables that hold those items – like wp_posts – reference the author by user ID.

Changing the umeta_ids should be safe, because that value isn’t referenced elsewhere that I’m aware of. It wouldn’t hurt to check your particular plugins and other tables to see if they are indeed referenced somewhere.

It would be safest to use a plugin to migrate the users. It does appear that you’ll have to have your old users reset their passwords, but that’s a smaller price to pay than getting customers, authors, etc. all confused.

A couple of possible options: Importing Users into new WordPress site and importing users where password is provided as md5 + much metadata.

Related Posts:

  1. Best practice to import user base (subscribers) from one website to another?
  2. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  3. Export WP database for import using WP-CLI on Vagrant Box
  4. MySQL Syntax Error upon restoring database from backup [closed]
  5. Export / import WordPress database
  6. Merging two databases without borking it
  7. How can i customize the export personal data file?
  8. Importer fails to import every post
  9. Is it good practice to import/export a blog to test a redesign?
  10. I broke database after reuploading local version – what exactly happened? Database error
  11. Why is my database import losing text widget data?
  12. How many users can WordPress handle?
  13. How to track user progress?
  14. Best way to import users, post and categories from an external database
  15. Performance tips for a large user base [closed]
  16. What’s the database relationship between a post and its attachments
  17. Importing posts from old website to new conflicting post ID’s?
  18. Exporting revisions
  19. When importing database, it shows error
  20. Efficiency on displaying random authors based on large database
  21. Extend the wp_users table
  22. Is a direct or import approach safer for migration into WordPress?
  23. How to use user table of a different database for WordPress users?
  24. Subscribers to posts
  25. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  26. Set Display Name to first and last name (phpmyadmin SQL Query)
  27. Importing New Posts from Live Site into Local Dev Site
  28. Select Multiple meta_value from WP DB; Single Query
  29. Getting all the users who have author privilege
  30. How much of my site can I recover from public_html?
  31. Does WordPress always create unique passwords?
  32. Import live site to local setup without access to live site
  33. In what part of the WordPress core does the users table and usermeta table get joined?
  34. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  35. Does WordPress Importer notify imported Users?
  36. Error establishing a database connection; After importing DB & Theme
  37. Modify Database in Multi-Site wp_usermeta table
  38. Change WordPress prefix for only one table?
  39. WordPress database import: Row size too large
  40. Create a clone from one WordPress site to another in a few minutes
  41. wp_get_current_user always returns 0 continued
  42. How to Mirror WordPress database from Remote server to Local server
  43. Exporting table to csv works in the admin but exports HTML data when used on the front end
  44. Is there a smart way to obtain a list of only some selected user meta data?
  45. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  46. Importing CSV into database table not working?
  47. How to Access wp_usermeta Data Immediately After a New User is Created
  48. Logins from WP users table use on another page
  49. WordPress Local And Live Site
  50. 2 WordPress sites with 2 databases but sharing the same users
  51. Connection refused on locahost after importing database?
  52. Convert user passwords to MD5?
  53. Importing Direct to DB – GUID Question
  54. Export a custom Mysql database product catalog to WordPress
  55. Does WordPress store the username as a primary key in the database?
  56. Is there a way to execute a php script outside WordPress?
  57. multiple wordpress installation with shared usertable on an different database
  58. Share users across multiple sites on same database, but with different domains
  59. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  60. Users table missing from Database [closed]
  61. Some weird users in database
  62. How to delete a particular row in a database table
  63. Recovering the table wp_usermeta from users
  64. WordPress database products structure
  65. Regenerate user_nicename column
  66. Storing user submitted forms [closed]
  67. WordPress where clauses in db select
  68. wp_insert_user not creating account correctly when ID is manually set
  69. Select From wpdb – Author/User Directory page
  70. Unexpected problems after importing WP data
  71. Can’t log into wordpress site – I have made a new user and still cant access
  72. Need help with creating a searchable user data by name or specific number like ID
  73. Bulk Edit Media Library alt, caption, image names
  74. Migrate Users From laravel to wordpress
  75. Display user data in numbered list
  76. User input to database
  77. how add more field to wp user and save it to database
  78. Move Non-WordPress users table to WordPress database
  79. Change user_nickname for author page link
  80. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  81. Export only a part of the database for migration
  82. Featured image from custom to WordPress database
  83. Exporting Post type from one theme and importing it to another theme
  84. how restrict user to give star ratings once for a post?
  85. create a table using user meta custom data
  86. How to get the id of recently registered user from database?
  87. How to save dropdown slection by a user in the DB
  88. How to get specific table by current user login
  89. update multiple user meta field based on another meta field
  90. Hash user emails in database?
  91. Changed meta_key value in structures, now dashboard shows zero users
  92. What WordPress file is saving new users to database
  93. Get id from database
  94. WordPress sync with phpbb
  95. import (migration) user database to wp-users
  96. Import Excel (or csv) Table with user-data as subscribers to wordpress
  97. export individual posts to text files or a single csv file
  98. Saving data to database and exporting to excel
  99. Importing Concrete5 content to WordPress
  100. WP Multisite Users Not Linking