Dev Env to Live Site – Tables NOT to Import

I have a Dev Environment and Live site.
The Live Site is at AWS on an Elastic Beanstalk with an RDS.
While the Dev Environment is just on a regular linux server.
We make all the changes on the Dev Environment and then use the AWS CLI and GIT to put it on the Live Site.
The issue is obviously the data on the Dev Environment won’t have the latest Affiliate / User & Group / WooCommerce Data, so we are listing our the Tables and Table Columns not to be modified.
The website is using the Affiliate Enterprise / Groups / Group Coupons / WooCommerce.
I wanted to see if you could verify that these are the tables that should not be modified.

Affiliate Enterprise
wp_aff_affiliates
wp_aff_affiliates_attributes
wp_aff_affiliates_relations
wp_aff_affiliates_users
wp_aff_campaigns
wp_aff_hits
wp_aff_referrals
wp_aff_robots

Groups
wp_groups_capability
wp_groups_group
wp_groups_group_capability
wp_groups_user_capability
wp_groups_user_group

WooCommerce
wp_woocommerce_order_itemmeta
wp_woocommerce_order_items

Users
wp_usermeta
wp_users

Gravity Forms
wp_rg_form
wp_rg_form_meta
wp_rg_form_view
wp_rg_incomplete_submissions
wp_rg_lead
wp_rg_lead_detail
wp_rg_lead_detail_long
wp_rg_lead_meta
wp_rg_lead_notes
wp_rg_userregistration

iTheme Security
wp_itsec_lockouts
wp_itsec_log
wp_itsec_temp


Comments

One response to “Dev Env to Live Site – Tables NOT to Import”

  1. antonio Avatar

    Hi Bo,
    yes, these seem to be the correct tables.
    Remember that Groups adds post meta values (“groups-….”) in wp_postmeta
    Regards,
    Antonio B.

Share