So if I follow you correctly this is not so much a new forum as an import of the current forum yes? The same website URL or a new one – I ask because that has implications later on…

I guess I am firstly curious as to why the WP user IDs would change if they were simply imported. But – that is probably not something I need to know now!

You really need to maintain the WP users, usermeta and all SP tables as a single unit and import all of these at the same time. This is the only way that relationships will be maintained. Simply backup up all of these tables in the source and then restoring them in the target database will keep everything in sync.

But perhaps a little more background and the methods you are using would be useful information to know…

Thank you for your answer… though it does make me nervous. The client is not changing their domain name, that remains the same. The users were not simply exported and imported because we did such a major reorganization of their website. We completely changed how they are using WishList Member, and simplified how their website was managed, and in doing so, the users were brought over in groups and reassigned permissions to the different areas of the site (I did not do this, a coworker did, so I do not have any other specific details). When the users came over to the new site, they were reordered starting at user number 101 and on… where the old user accounts had started at 1 and went on.

I am using PHPMyAdmin to import and export the SP tables. The WP & WL tables were not imported using PHPMyAdmin, they were uploaded I believe using WP. I will export the WP, WL & SP tables from the old live site and import them into the new database using PHPMyAdmin, and hopefully that will solve the problem of user accounts. Then if I have to go through and reassign permissions in WishList, that is a much smaller problem than having to fix tables of users.

Please let me know if I need any other information, or if there is anything you can think of that I need to watch out for. I will try to solve this problem this morning so we can launch the client’s new website.

I will let you know how it goes.

As long as they are bou8ght across in concert then it should be fine. This has happened with a lot of our users and I more or less do this regularly with test data.

About the only think that comes to mind is the question of whether you are also bringing the WP post and page records across as SP does create a page record for display. If that is not bought across then it will have to be manually created but that is just a minutes task.

Wanted to update… bringing over all the user tables at once (in WP, SP, and WishList Member) did the trick! Thank you for confirming my initial ideas about the migration process. Bringing over the tables was not perfect, but the clean up work after was minimal.

Thank you for your answers to my questions and help steering me in the correct direction.

That’s great news. Thanks for the update to the thread.