Export Users with passwords

  • I need to make a site migration as transparent as possible by migrating the users with their existing passwords. I have scoured the plugins and the forums and mostly the issue is that passwords are encrypted.

    Firstly is there a plugin or curl script that can do this WITH the passwords?
    Secondly can I reimport with the passwords intact?

Viewing 3 replies - 1 through 3 (of 3 total)

  • Are you replacing the existing site, or just moving hosting?

    If you are replacing the site you could try to export the users and user_meta table data and import this into the new site, if there are users already setup with the same primary key, these will need to be updated in both tables so the data remains the same.

    If you are moving hosting, I assume you have an export of the database, when imported no data will have changed.

    Hope this helps.

    Thread Starter patbell101

    (@patbell101)

    I have tried a couple of export users with meta plugins but none seem to include the password (unless its cryptically named, there is a LOT of meta field headings)

    fwiw I have developed a new site on a new server in order to stage it. I now want to import the users and just switch them over (they access it via a public site menu option so I can just change the url).

    They are all difficult and complain about the difficulty of the passwords required so I would rather avoid them all having to reset their passwords if at all possible

    paralleljames

    (@paralleljames)

    Hi Pat,

    I am unable to find a plugin that does this

    I personally would do this direct in SQL and at a guess PHPMyAdmin.

    If you export the tables, this can be imported into the SQL of the new site.
    The MD5 hashes won’t be changed so the passwords will remain secure and the same as presently.

    Before importing the data into the table you will need to check that none of the existing user ID’s exist. If they do one of the sets will need amending, at minimum this will be your administrator login user ID 1.

    If other users have been added directly onto this installation they will have user ID’s that depending on how you import the data will be overriden or not imported.

    If this is outside your technical expertise, it would be best to hire a SQL/WP Expert that would be able to perform this, it shouldnt be more than a hours work, but would depend on data within the tables.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export Users with passwords’ is closed to new replies.