Link to home
Create AccountLog in
Avatar of Leroy Luff
Leroy LuffFlag for South Africa

asked on

Export\Import Users Wordpress

Good day,

My webdevelopers is struggling to export users out of an old wordpress site into the new site. The issue is with the password.

The password does not work unless you reset it in new site.

Is there a plugin that can assist us that will make original passwords work on the new site or any other means of exporting and importing users?
ASKER CERTIFIED SOLUTION
Avatar of Tim Brocklehurst
Tim Brocklehurst
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
I think MySQLDumper is what you want to take a look at.

And its a free tool too :-)

good luck, and YES: Backup :-)

regards, W
If you have access to both databases, it is quite easy:
insert into new_database.wp_users(
login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,
display_name
) 
select
login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,
display_name 
from old_database.wp_users;

Open in new window

Obviously, adjusted for your circumstances.