Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › WP eMember – How to migrate users, passwords, settings
Tagged: Database Migration, migration, new server migration, Transfer
- This topic has 6 replies, 3 voices, and was last updated 6 years, 8 months ago by wzp.
September 8, 2016 at 11:19 pm #13701
We’ve developed a new version of our website.
How do we migrate our eMember user data, passwords & WP eMember settings to our new site?
Note that the new site uses a new database, so copying the entire old database over is not an option. However, we can copy individual tables & records if you tell us which ones we need.September 9, 2016 at 1:45 am #74099adminKeymaster
Transfer all the database tables that has the emember keyword in it. The emember keyword in the database table name indicates that the table was created and used by the emember plugin.
The following posts have more info:
Emember- Can I get instructions on how to move emember to a new domain
https://support.tipsandtricks-hq.com/forums/topic/transfer-settings-to-another-forumSeptember 9, 2016 at 1:47 am #74100adminKeymaster
The passwords will likely need to be reset as the encryption salt will have changed on your new install.
The passwords are kept using a ONE WAY hash. So you can’t look at the database and get passwords (this is the best security practice for storing passwords).
The following documentation of WordPress has explanation on how passwords are hashed in teh WP system. We use that same functionality in our WP eMember plugin also:
https://codex.wordpress.org/Function_Reference/wp_hash_passwordSeptember 12, 2016 at 9:32 pm #74101
Ok, can you explain how development is done in cases where you need to make changes to the website on a separate development server and then migrate those changes back into production? Because that’s essentially what we’re doing here.
If there isn’t a way (which doesn’t make any sense to me?) then can you please tell me how we can automatically update the passwords for all 2,000 of our members (e.g., have us set them all to the same password)?
Thanks.September 12, 2016 at 9:49 pm #74102wzpModerator
“Development servers” and “production servers” usually have different sets of users. Development servers typically have “just enough” test user accounts, to validate changes; whilst the production server has all of the “real” user accounts.
What gets moved from the development server and the production server is just the “code base” and those parts of the WP database that contain updated pages.
Are you using experienced programming developers; or are you trying to learn as you go along?September 13, 2016 at 8:11 pm #74103
I’ve been developing websites and web applications since 1994. I’ve been developing WordPress websites specifically for several years.
What would be involved in getting a script we can run that will go through and set every single member’s password to “foobar”?September 13, 2016 at 10:53 pm #74104wzpModerator
What would be involved in getting a script we can run that will go through and set every single member’s password to “foobar”?
There is no way to do this, because every eMember system uses a different random number seed, for password encryption. The only way to preset the passwords, and it may be painful for you, is to use the eMember –> Members panel to manually edit and set each user password; after the import, to whatever the desired value is.
Yes, it probably could be automated, but it would be a custom coding job:
- You must be logged in to reply to this topic.