[horde] Fwd: Need help to merge 4 seperate horde installs
Daniel A. Ramaley
daniel.ramaley at DRAKE.EDU
Tue Nov 21 06:34:43 PST 2006
If i had to do this, first i'd verify that all 4 servers are running the
same versions of the same Horde components. Then i'd decide which of
the 4 installations will be preserved (the master). Make backups of the
database on that machine, and test that the backups can be reloaded.
Then pick one of the other machines to be merged with the master and
dump its database tables. Examine the dump file and make sure tables
will not be dropped when it is reloaded, then try loading it on the
master. Shut down the machine whose database was copied over, and tell
people who formerly used it to use the master machine instead.
I don't know if this will work or not, but it is how i would start
thinking about the problem. One obvious limitation is that if people
have preferences on multiple Horde installations, only 1 set of
preferences will survive. If there are not many such people, it may be
easiest just to tell them that they might lose some data, and if they
are concerned about address books or other really important data that
they export a copy for themselves and import it after the migration.
But if most of the users have used more than one Horde server, then
you'll need to come up with a more elaborate plan to merge the
databases. Whatever you do, make sure you have verified backups before
Someone with more knowledge of Horde internals, feel free to tell me how
my plan would blow up and cause data loss.
On Tuesday 21 November 2006 05:41, netty 2006 wrote:
>Can anyone help me with this?
>---------- Forwarded message ----------
>From: netty 2006 <netty2006 at gmail.com>
>Date: Nov 19, 2006 7:03 PM
>Subject: Need help to merge 4 seperate horde installs
>To: horde at lists.horde.org
>We have 4 seperate horde 3.1.1 installs on seperate servers.
>Now we wish to run a seperate horde server that serve users of all 4
> installs. Here i need help on merging user preferences, address
> books, memos, etc for all 4 installs into one.
>I tried to lookup but couldnt find an adequate anwer anywhere.
>Can someone guide me how should i go for this merge?
>Another problem i have is duplicates in a few installs.
>Like someuser at domain.com may exist in 2 installs, so it may create an
>issue in merging them.
>As i see there isnt a straight way, but even if someone can guide, it
>will help a lot.
>Even if it needs scripting or data transformation of some sort.
Dan Ramaley Dial Center 118, Drake University
Network Programmer/Analyst 2407 Carpenter Ave
+1 515 271-4540 Des Moines IA 50311 USA
More information about the horde