Which tables to move to new site.

  • Bill Van Vlack
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 2 months ago - 3 years 2 months ago #141010 by Bill Van Vlack
Which tables to move to new site. was created by Bill Van Vlack
We are moving our website to a new host and have set up a test site there that will become the new site when we move the domain.
We have loaded Membership Pro on the new site, moved the tables from the old site for testing, and have made changes on the new site - adding plans, front end menus, etc.  The question is: when we shutdown to move the domain, what tables do we need to move from the working site to the new site? 
I figured that:    
We need to move....
 Tables that have changed on the old site since they were moved the first time.
We don't want to move....  
 Tables that we have changed on the new site
We don't need to move....  
Tables that are the same on both sites.  
Tables that are empty on both sites

 I've done that analysis and the result is that we need to move the emails, fields, and subscribers tables. Does this sound like the correct approach?
 
Last edit: 3 years 2 months ago by Bill Van Vlack.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #141016 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Which tables to move to new site.

Please Log in or Create an account to join the conversation.

  • Bill Van Vlack
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 2 months ago #141074 by Bill Van Vlack
Replied by Bill Van Vlack on topic Which tables to move to new site.
Don't want to move all, since we've changed Plans, etc. on the new site. Just want to move info for new/expired/approved subscribers.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #141075 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Which tables to move to new site.
Only subscribers? And no plans?

If so, you will have to move data from following tables:

1. Tables related to Joomla user accounts

jos_usergroups
jos_users
jos_user_keys
jos_user_notes
jos_user_profiles
jos_user_usergroup_map
jos_viewlevels

2. Table related to subscribers data

jos_osmembership_subscribers
jos_osmembership_field_value

Tuan

Please Log in or Create an account to join the conversation.