Managing Multiple Install Instances

Monday 25 August 2008 3:43:02 pm

Hi everyone,

I wanted to ask if any has encountered a scenario such as mine, or if not, to suggest a better course of action, if indeed there is one! :-)

We currently have 2 eZ 4.0.1 installs running on MySQL 4.1 behind Apache 2.2.8 on two different ports.

* DEV (8085: DEVelopment)
* ED (8086: EDitorial)

The idea is that new template/CSS design stuff, content objects and other custom mods should be made and tested on DEV and these changes then ported to ED, once confirmed working as desired for our uses.

I wanted to ask if anyone is doing something similar, and how they managed to successfully "merge" changes from one to the other. We are using SVN to track our changes, and I'm sure this might figure in some solution?

At present, my only idea is to periodically copy across:

* All settings files from DEV to ED.
* All design, template, CSS extension files from DEV to ED.
* Export only structural DB data (ie: not content) from DEV and import into ED.

However with regard to the latter, I'm unable to find a recent enough DB Schema (and description) that will tell me which tables deal with content (Text, non design images, uploaded files etc)

Has anyone done anything similar or is mine not the most intelligent approach?

Where can I find a recent eZ DB Schema? I can't use Rational XDE as it doesn't seem to support MySQL (We have an older version, maybe the newer one does??) but even if successful, this won't tell me what tables are used for content and which for config/structural data.

Thanks a lot for your time.
Russ

Russell Michell, Wellington, New Zealand.
We're building! http://www.theruss.com/blog/
I'm on Twitter: http://twitter.com/therussdotcom

Believe nothing, consider everything.

Tuesday 26 August 2008 5:45:40 pm

Thanks for your reply Gaetano,

I re-read my original post, your reply and re-read that SVN article - but I now feel as though using SVN as the tool for this may be overkill because the only point of difference between each instance is only ever going to be content (text, images, uploaded files).

So when I make changes to DEV, it is no problem to wholesale copy them to the document root where PROD is located.

So if the only difference is likely to be in website content, it seems all I need to do is ensure these are left untouched in PROD when a data transfer from DEV to PROD is made. This is why I was asking after the location of an up-to-date ez DB schema and table description so I know which tables to omit in the import.

Thanks for your reply anyway, it has made me think a little more about it :-)

Cheers,
Russ

Russell Michell, Wellington, New Zealand.
We're building! http://www.theruss.com/blog/
I'm on Twitter: http://twitter.com/therussdotcom

Believe nothing, consider everything.