I have been building my site on a dev server, while I've had a live site running on another server. Both are multisites, with buddypress. And in the time since I started developing on a different server, new users and posts have been added to the live site.
Now I need to get the users and posts into the new site. I'll refer to the new site as "beta" from here on.
I thought I should do this by cherry picking the right tables in the database, but some things aren't going right.
The subsites have the same IDs on both servers. BuddyPress is network activated, but I also have the BP_ROOT_BLOG defined as a constant in wp-confg as site id=20.
Before I got started with the database, I synchronized the plugins on both sites and updated everything to the latest version.
Using phpMyAdmin, my export settings are to select "custom", leave everything as is except I check the "Add DROP TABLE" option.
I exported from the live site:
- wp_wangguard* (our spam prevention plugin, which involves users)
then imported those tables to the beta site.
then I exported all the wp_20_bp_* tables and wp_options and imported those.
At this point, I realized that my users are all messed up. For example, a recently created test user on the beta site has been merged with a user from the live site. We see her username, and his profile information. It looks like it may have matched up user IDs from the two systems just on the more recent users. The older users seem to be OK. This tells me I might just need to delete all the test users before importing the user tables.
Anyway......I reverted those changes, and tried instead to export/import all the database tables for site 20. But that botched up my theme pretty badly, because the live site is using a different theme.
So I'm looking for advice on the best course of action.
My concerns here are -
- I need all the forum posts to match up with the users who created them.
- I need the users to be assigned to the right BP groups.
- I need all the users from the live site, particularly those created since May.
- I am fine with losing all the test users created since May.
Any advice will be greatly appreciated. I am supposed to have this done by Monday morning (Pacific time).
Thanks in advance!!