Re: Large File Revision Control??

[Greg A. Woods]

First off please note that even though you've posted to what you see as
a newsgroup, this is (now again) a bi-directional news/mailinglist.  If
you want any sensible help at all you MUST use a working From: header.
The value "From: BCC <address@hidden>" is pretty useless to 100% of e-mail 
users!

You didn't even include a workable e-mail address in the body of your
message!

[ On Thursday, August 23, 2001 at 11:20:28 (-0700), BCC wrote: ]
> Subject: Large File Revision Control??
>
> What we have are many MySQL tables that must be synchronized across a
> network ( this is on linux btw ).  i.e. There is one development
> machine, and when I or whoever is working on the DB would like, we can
> update 2 other machines with the same databases. Replication was our
> first attempt, but since the master was also being used for development,
> replication kept crashing.  

OH MY GOODNESS!!!  Talk about using the WRONG tool for the job!

You REALLY REALLY REALLY want to learn MUCH more about DB replication
and forget all about any kind of version control system or file-transfer
application for this!

If I'm not mistaken PostgreSQL has some fairly workable replication
tools already built right into it.  There's also the "free" version of
Oracle which may also include the necessary bits.

(I suppose you might try rsync too, but I'd MOST STRONGLY recommend only
ever doing this kind of thing from directly within the DB engine!!!!)

-- 
                                                        Greg A. Woods

+1 416 218-0098      VE3TCP      <address@hidden>     <address@hidden>
Planix, Inc. <address@hidden>;   Secrets of the Weird <address@hidden>