Exporting, Importing, migrating users in wordpress | phpmyadmin

Exporting and importing users from wordpress to wordpress

1. wp_users is the primary table, with a fixed list of columns.
2. wp_usermeta is an additional table for storing arbitrary information (custom fields).
3. The wp_users table already has a user_email column, so I don't know why the plugin uses wp_usermeta. I guess the best person to ask would be the plugin author himself.

Descriptions:

• WP1= my old site
• WP2= my new site

Tables:
wp_user and wp_usermeta (you need to change the wp_ if needed)

Export
from WP1 wp_user and wp_usermeta (separatly)
download the 2 sql files

Prepare sql files:

1. In gedit do Ctrl+H (find and replace)
2. replace database name
3. replace tables changes (may be from wp_ to what_ever_your_string)
4. save and keep

Upload:

1. Go to your dtabase for WP2
2. do a backup of the dB
3. delete tables wp_user and wp_usermeta
4. import new (fixed sql files) for wp_user and wp_usermeta
5. test
6. evaluate database