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:
- Combining user database tables while keeping all other data in seperate for multiple sites?
- Sharing users across multiple sites, each on their own database
- How to share User Database between Two Multisite Installations + More
- How to use the same users table on multiple wordpress sites
- WordPress automatic Login on other page?
- How to use 2 different databases but share the same user in wordpress
- How To Add Custom Form Fields To The User Profile Page?
- How can I trust switch_to_blog()?
- Why are my roles not visible in a Multi-site/Network?
- How to use same email for multiple users
- Where can I find documentation on what characters are allowed in user names and why?
- DB connection error after copying a WordPress Multisite instance to a second location
- Is there a is_user_logged_in() for multisite?
- Add WordPress MU Network Admin via Database
- How to tell which database tables belongs to which multisite site
- what are pmxi tables? [closed]
- WordPress Multisite allow site admin to add user without email confirmation
- wordpress multisite, how to keep user on subdomain throughout registration process?
- Network not displaying all sites and users
- WordPress Multisite – When a user signs-up on main site, how to add the user to a subsite
- How to use alias domain for multisite installation?
- Give to site admin the option to “skip confirmation email” when adding new user
- Shared table across network
- Different back-end colour scheme for the different sites of a multisite
- find a random blogid across my multisite network that has at least one post published
- Set up collaborative site
- WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
- Multisite: How to store global options vs. site options?
- Uploading/Deploying a Multi Site Install
- Multisite database upgrade SSL error
- Configure WordPress to read from database only, never write
- How does WordPress connect sites and the wp_users table?
- Prevent user creating new users with specific roles
- Multiple Domains and Subdomains Using Multisite Installation
- Allowing logged in users to comment without moderation across a multisite installation
- Can you have multi-site WP and keep users separate?
- Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
- Migrating WPMS from apache to IIS7 causes Database Error
- Synchronizing Two WordPress Sites Content
- How to add multiple existing users to a multisite site?
- How to clone and locally run a network for testing
- the blog owner multisite
- Two WordPress sites sharing the same database
- How can I get multisite primary blog (url or path) for current user?
- Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
- Split a database will improve performance?
- Why can’t I delete original user in multisite? Options for manual removal
- How to Move Local Singlesite Database to Remote Multsite Database?
- Multisite Subdomain Using More Resources Than Others?
- Can I use multisite functions in a single-site installation?
- How to add edit users capability to a custom role?
- How to change the database prefix in multisite (WPMU) install
- WPMU – new users are automatically subscribed to the main blog – how to prevent that?
- Importing Multiple DB to one MU database
- In MultiSite, can some users automatically have Site Admin rights on all sites, without granting them Network Admin access?
- Make WordPress Search for Both Main Domain and Subdomain
- Does WordPress MultiSite use separate MySql databases?
- How can I delete a user from entire multisite nework
- delete_user_meta : how to delete all the metadata of a given user (witout SQL)
- Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
- Multisite setup creating custom table
- How to search users globally on a multisite install?
- Is there a way to run upgrade.php for one blog?
- Within the database, where is the flag which says that a user has Super Admin rights?
- Update User Role Across Network when Main Site User is Updated
- Bulk activate a theme on multisite
- Assign role to user on first login, if they are first (after admin)
- Get the User ID Who Owns a Given Blog ID in Multisite
- Migrating Multisite – Database error, missing wp_blogs table
- Make a user administrator to a sub directory site and a contributor to main site in multisite network
- How to store custom user data on the database?
- Displaying a message upon user registration
- Query users by capability – uninstall/deactivate callback
- WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
- How to change user starting role in WordPress MultiSite?
- Database Tables Lost Indexes? How to Recover?
- Multisite – One user allowed access to all sites?
- Add a user to a specific blog when they register?
- Installed domain-based Multisite but can’t access wp-admin (redirect loop)
- How do you disable account activation in WPMU and then log the user in right away?
- Multiple multisite instances connecting to the same database
- WordPress Multisite – can I somehow merge the tables?
- Four columns in the wp_users table
- Multisite with subfolders- can’t access main site- Error establishing a database connection
- Good way to block users within a multisite setup without deleting them?
- Create a database for each site created in multisite?
- Use WordPress MultiSite (WPMS) with a remote database for each created site
- Subsite access without being a member of the subsite in wp multisite network
- Will changing the folder name two directories above a fresh wordpress installation break the site?
- WordPress Multisite blogs not working after domain swap
- Least expensive way to get table prefix in multisite installation
- Create Custom Multisite User Role to Reduce Capabilities
- 2 website 1 database… Local to online
- Obtaining user table for one site on multisite set up
- new multisite, old db
- Removing Mutlisite lines stop DB connection
- WordPress stuck in deleting user
- how to migrate wpmu from one host to the other?
- How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
- Share DB tables between two blogs on the same WP Multisite installation