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
- WPDB Insert or if exists Update
- get_results using wpdb
- $wpdb won’t insert NULL into table column
- How to fetch Data in WordPress using MySQLi or $wpdb
- wpdb->insert multiple record at once
- How to define composite keys with dbDelta()
- Does wpdb add considerable overhead on queries with large result sets?
- Hook into $wpdb
- How does $wpdb handle COUNT(*)
- Importing posts from old website to new conflicting post ID’s?
- Exporting revisions
- WordPress database error: [Query was empty] [closed]
- Efficiency on displaying random authors based on large database
- How to execute mulitple statement SQL queries using $wpdb->query?
- When and why should I use $wpdb different return types?
- Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
- How wordpress accesses its own database
- 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)
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- How to use a different database to list and manage comments in the backend
- Cannot update custom database table row
- wpdb_prepare with multiple or condition
- Show last modified date of database
- $wpdb->insert is not working
- Extracting the post_id via the wp_insert_post action (external db query)
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Change WordPress prefix for only one table?
- Multiple wp_options tables to share content across installs
- Select two sums with single get_var statement
- Is there a smart way to obtain a list of only some selected user meta data?
- Update from 4.5 to 4.6 failing
- WordPress Local And Live Site
- MS Access to manage WordPress Database
- 2 WordPress sites with 2 databases but sharing the same users
- WPDB SQL query with prepare() returning variable, not db value
- $wpdb error (Call to a member function insert() on a non-object)
- Is it important to have integers inserted using %d rather than %s?
- Export a custom Mysql database product catalog to WordPress
- Is there a way to execute a php script outside WordPress?
- Problem in using wpdb
- Best practice to limit results in get_row()?
- Share users across multiple sites on same database, but with different domains
- Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
- CreateOrUpdate in WordPress
- Trouble running $wpdb->query() with last_insert_id
- How to get a list of WordPress default database tables?
- Using $wpdb | checking entered email against existing emails in db
- Optimizing function that automatically creates internal links based on post title string
- Get results from wordpress data custom table
- Outputting query results
- WordPress where clauses in db select
- add_post_meta — not working
- Creating and Using Tables in the WordPress Database
- Need help with creating a searchable user data by name or specific number like ID
- $wpdb->insert not inserting all rows
- SELECT rows between two datetimes when the range is dynamic [closed]
- How to insert a value to decimal type field using wpdb->prepare?
- Migrate Users From laravel to wordpress
- Insert NULL value using prepare()
- how add more field to wp user and save it to database
- $wpdb->insert duplicating rows
- Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
- Where is the HTML-handler part in the wpdb class?
- Featured image from custom to WordPress database
- Exporting Post type from one theme and importing it to another theme
- WordPress Database Query works in phpMyAdmin but not in the code
- How to save dropdown slection by a user in the DB
- Correct and secure way to access a custom SQL database in a custom PHP template file
- Using $wpdb to insert data into a table
- Processing a lot of $wpdb isn’t insert all the data
- What WordPress file is saving new users to database
- How can I retrieve data from alternate database using wpdb class?
- WordPress sync with phpbb
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- How to use remote db tables in current config? [duplicate]
- How to delete field using WPDB?
- Importing Concrete5 content to WordPress
- 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