- Posts: 83
- Thank you received: 0
Which tables to move to new site.
- Bill Van Vlack
- Topic Author
- Offline
- Premium Member
Less
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?
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
Less
More
- Posts: 83
- Thank you received: 0
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
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.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.