exporting/importing users using phpmyadmin

[aimlesslady]

I have migrated from Joomla 3 to 4. While I was doing the migration on the development site, new users registered on the live site. I want to export the users on the live site and import them via phpmyadmin. I need help identifying which tables I need to export and the settings for a Custom Export option.
I may also have to do this for my JGive component since they have an export option but no import option in the component interface. If you can help with that as well, that would be helpful.
Thanks in advance.

[cmbay]

I want to export the users on the live site and import them via phpmyadmin. I need help identifying which tables I need to export and the settings for a Custom Export option.

To get you started, I suggest examining the #__users table of the old site. Sort that table in PHPMyAdmin on the registerDate column. Export the newest entries and then import them into the live site.

[aimlesslady]

Thank you, so all tables with #__users.
What about the Custom settings. Leave the default?

[cmbay]

Thank you, so all tables with #__users.
What about the Custom settings. Leave the default?

I've told you more than I know about the subject of user database tables. It's now time for some one with more experience than I to chime in.
By the way, how many interim users do you want to import? A handful? Dozens? Hundreds?

[toivo]

There are other tables associated with the _users table. The contents of the tables listed below, other than _user_usergroup_map, may be empty, depending on the features the website is using:
_user_keys
_user_mfa
_user_notes
_user_profiles
_user_usergroup_map

Does the website use custom fields for users? If it does, then new users may have data stored in the table _fields_values.

[Webdongle]

If it was not many new users perhaps email them and ask them to reregister?
Or try https://extensions.joomla.org/extension ... p-upgrade/
There maybe others