Export Users with all fields and passwords to new Joomla 6 website

Hi,
I need to transfer users from Joomla 5 to clean Joomla 6 website with all fields and passwords. Using the export option in user management it doesn't included all groups, even though the user groups and ids are identical, or passwords. Is there a way to do this without having to export tables from the database?  

Import/export of user management is just an import/export of the _comprofiler table. It won't re-create fields for you. Is there a reason you're not just migrating Joomla 5 to Joomla 6? What exactly are you trying to clean out? Moving all of CB and your Joomla users requires migrating over a substantial amount of database tables.

Hi Krileon,

I want to move all registered users, including their groups and passwords, to the new website under construction. The export option in User Management only exports the comprofiler table. The remaining information is in the users and user_usergroup_map tables.

So I guess I will have to use pphmyadmin and export the tables then append them to the tables in the new website database, excluding the main admin user account.

So I guess I will have to use pphmyadmin and export the tables then append them to the tables in the new website database, excluding the main admin user account.

Yes and no. User ids are auto incremented. So it's an all-or-nothing move. Your new admin user is likely occupying a user id already in use. There's several tables you'll have to move that are related to users. The relevant tables are as follows.

_users
_user_keys
_user_mfa
_user_notes
_user_profiles

The users ACL assignments would also be related to the below tables.

_user_usergroup_map
_usergroups
_viewlevels

As for CB data then all tables beginning with the following are relevant.

_comprofiler
_cbsubs
_groupjive

Thanks, a bit more work but better than asking customers to register again. Plus comprofiler images to be moved to new platform.