I would setup your Website B, add a user through the control panel, then view what tables in the database they were added to and what extra fields were set. Then use Navicat or phpmyadmin to dump users from Website B into excel, combine the users from Website A, set any missing fields then import to Website B
Related Posts:
- Import users from old WP site to new one
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Export WP database for import using WP-CLI on Vagrant Box
- Export wordpress table to excel
- MySQL Syntax Error upon restoring database from backup [closed]
- Getting all the users who have author privilege
- In what part of the WordPress core does the users table and usermeta table get joined?
- Modify Database in Multi-Site wp_usermeta table
- Export / import WordPress database
- Merging two databases without borking it
- How can i customize the export personal data file?
- Importer fails to import every post
- How to delete a particular row in a database table
- Is it good practice to import/export a blog to test a redesign?
- Select From wpdb – Author/User Directory page
- How to get specific table by current user login
- I broke database after reuploading local version – what exactly happened? Database error
- Using wpdb to connect to a separate database
- Why is my database import losing text widget data?
- WPDB Insert or if exists Update
- Multiple developers / editors working on a site in progress
- get_results using wpdb
- $wpdb won’t insert NULL into table column
- How many users can WordPress handle?
- Get error messages when $wpdb->insert() returns false?
- Detecting errors generated by $wpdb->get_results()
- Does dbDelta delete columns as well?
- wpdb update add current timestamp not working
- How to fetch Data in WordPress using MySQLi or $wpdb
- wpdb->insert multiple record at once
- WordPress Unit Testing – Cannot Create Tables
- How to define composite keys with dbDelta()
- Does wpdb add considerable overhead on queries with large result sets?
- How to track user progress?
- Why does $wpdb return strings for mysql integer values?
- $wpdb->prepare() warning in WordPress 3.5
- Inserting data into custom tables
- Hook into $wpdb
- Display data from a non wordpress database on a page template
- How does $wpdb handle COUNT(*)
- Best way to import users, post and categories from an external database
- Performance tips for a large user base [closed]
- What’s the database relationship between a post and its attachments
- Importing posts from old website to new conflicting post ID’s?
- How might I retrieve a featured post image from an external WP site and display it as a link back?
- Exporting revisions
- WordPress database error: [Query was empty] [closed]
- When importing database, it shows error
- How to close wpdb connection? [duplicate]
- Inserting Post Meta From SQL
- Why does dbDelta() not catch MysqlErrors?
- Connecting to external oracle database
- Efficiency on displaying random authors based on large database
- Can’t save ajax value to database
- What causes the “max_user_connections” warning on WordPress frontend?
- $wpdb variable throw this error Call to a member function get_results() on a non-object in
- Extend the wp_users table
- Updating all rows of table with $wpdb
- Safe way to find last inserted id in a table?
- How to execute mulitple statement SQL queries using $wpdb->query?
- Is $wpdb->prepare escaping to much? How to use it properly?
- Database slowdown after update to 3.4.1
- Is a direct or import approach safer for migration into WordPress?
- How to use user table of a different database for WordPress users?
- When and why should I use $wpdb different return types?
- Subscribers to posts
- Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
- How wordpress accesses its own database
- Remove database entries where post_date > expiration date
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Importing New Posts from Live Site into Local Dev Site
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Get data from database using $WPDB
- Select Multiple meta_value from WP DB; Single Query
- How to use a different database to list and manage comments in the backend
- How much of my site can I recover from public_html?
- Multiple postmeta with same name for one post in wp_postmeta table
- WP Database Table to CSV file
- Cannot update custom database table row
- WordPress sync with phpbb
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- Creating Tables in WordPress Database
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Inserting into data into external DB using WPDB
- Insert Extra fields added in the front end registration form to DB
- How to use remote db tables in current config? [duplicate]
- export individual posts to text files or a single csv file
- Saving data to database and exporting to excel
- $wpdb->insert not working for last select option
- $wpdb->prepare returns empty array
- How to delete field using WPDB?
- Importing Concrete5 content to WordPress
- WP Multisite Users Not Linking
- Uploading to WordPress Database
- $wpdb->update is not working until next page refresh. Is there one more step?
- how to run tests using different db connection
- SQL errors when querying for something with apostrophes
- Problem while importing a site in WPLocal: SQL files fail to import