Discussion Forum

tsamant

Member

From: Chicago

Registered: May 14, 2015

Posts: 52

Content change saga (continued)

Hello,

To recall, I am trying to "unveil" a large number of content changes (to pages and tree structure).

At this point, dump-from-stage/undump-to-live seems to be the only option.

But there are other parts of the live DB that really can't be overwritten (e.g. calendar). So I am trying to get a minimum list of tables that need to be synced.

There are four page operations being performed on stage:

1. Create new
2. Edit
3. Move to another parent
4. Delete

So far, I believe these have effects on: bigtree_pages, bigtree_route_history, bigtree_audit_trail.

So I think that dump/undump on these three will do the trick. Is there anything I am missing? Thanks! Tushar

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 974

Re: Content change saga (continued)

bigtree_pages and bigtree_route_history should be all you need. The audit trail table is just tracking who changed what (so if it's all you doing the changes it can probably remain unchanged).

tsamant

Member

From: Chicago

Registered: May 14, 2015

Posts: 52

Re: Content change saga (continued)

That's the best news ever! Thanks for keeping things, as they say, loosely coupled. Tushar