asked on 2/17/2016

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?

WordPress HTML Blogs

Last Comment

William Nettmann

2/19/2016

ASKER CERTIFIED SOLUTION

Tim Brocklehurst

2/17/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

radioflyer ger

2/17/2016

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

William Nettmann

2/19/2016

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.