I now have my live site running drupal 4.7.2 with a number of add-ons modules (including CCK, userreview...).
I have a test site that is a replicate of the Live environment. Let's call it Reference environment.
On my lovely iMac at home I have my development environment.
Usually I take a copy of the live environment and then develop on top of it, this means:
- changing the theme
- adding modules
- changing configurations of blocks, modules...
When I am happy with the new set-up I would like to update my reference then Live environment with my new configuration BUT keeping the live content that is changing day after day (forums, book...).
So I would need to copy only the 'configuration' bit and not the 'content' bit...so only some tables:
- node
- node-content (created by CCK)
- votingapi...
This means a partial copy of the database to the live environment from the dev/test environment.
I wanted to know what are your experience in doing such update and your tips !
Cheers