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
- Multiple developers / editors working on a site in progress
- get_results using wpdb
- Detecting errors generated by $wpdb->get_results()
- wpdb update add current timestamp not working
- wpdb->insert multiple record at once
- How does $wpdb handle COUNT(*)
- 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]
- Safe way to find last inserted id in a table?
- Database slowdown after update to 3.4.1
- Is a direct or import approach safer for migration into WordPress?
- When and why should I use $wpdb different return types?
- 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?
- Select Multiple meta_value from WP DB; Single Query
- How much of my site can I recover from public_html?
- Multiple postmeta with same name for one post in wp_postmeta table
- Cannot update custom database table row
- Import live site to local setup without access to live site
- 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?
- Change WordPress prefix for only one table?
- Multiple wp_options tables to share content across installs
- $wpdb doesn’t like to store arrays
- Select two sums with single get_var statement
- How to Mirror WordPress database from Remote server to Local server
- Is there a smart way to obtain a list of only some selected user meta data?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Importing CSV into database table not working?
- Update from 4.5 to 4.6 failing
- WordPress Local And Live Site
- How Can I Put Meta_Compare in the Database-Query?
- MS Access to manage WordPress Database
- WordPress running SQL query to update database from form
- WPDB SQL query with prepare() returning variable, not db value
- $wpdb error (Call to a member function insert() on a non-object)
- Have working sql query… trying to adjust it to use $wpdb
- Is it important to have integers inserted using %d rather than %s?
- Export a custom Mysql database product catalog to WordPress
- $wpdb->query can’t insert data
- Custom WordPress Table wpdb
- Best practice to limit results in get_row()?
- Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
- CreateOrUpdate in WordPress
- Problem migrating to localhost
- 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
- Recovering the table wp_usermeta from users
- 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
- Creating and Using Tables in the WordPress Database
- How to escape percentage sign(%) in sql query with $wpdb->prepare?
- 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
- User input to database
- how add more field to wp user and save it to database
- Change user_nickname for author page link
- Where is the HTML-handler part in the wpdb class?
- Exporting Post type from one theme and importing it to another theme
- How can I get $wpdb to show MySQL warnings?
- Correct and secure way to access a custom SQL database in a custom PHP template file
- About wp database hooks (error establishing connection)
- Should I Use only wpdb Class to Write Custom Queries?
- Hash user emails in database?
- 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
- Saving data to database and exporting to excel
- How to delete field using WPDB?
- WP Multisite Users Not Linking