Re: [Openinteract-help] sync-ing users on 2 machines

[Chris W. <ch...@cw...>]

* Andrew Hurst (hur...@ll...) [031031 18:34]:
> So you want to migrate the users only?  I assumed you wanted to 
> mirror the whole database...
> 
> For users only, I'm not sure.  I'm cc'ing this back to the 
> openinteract-help list so someone more knowledgeable (Chris) can 
> clear that up.

** Adrian Arva wrote:
> >that would be the easy way, proovided that
> >there are not other tables that I would have to update based on user ids 
> >and
> >groups and other settings.
> >Actually my question is at this level: to import the user from one set-up 
> >to
> >another one (let's assume I have two OI sites siteA on machineA and siteB 
> >on
> >machineB) do I have to take care of something else than just the sys_user
> >sys_group tables?
> >Do I have to update other tables too?

I'm not sure why you'd just want to update the user tables, but off
the top of my head you should just need to update:

 sys_user
 sys_group
 sys_group_user

Periodically dumping the database and scp'ing that to the remote
machine will probably do the trick for quick-n-dirty replication as
well, depending on how big your site is. The best possibility is to
rely on whatever the database may use for replication, leaving out
frequently-updated tables like 'sessions'.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988