I lost the original to this thread, but I thought some comments may be usefull.
First of all, rsyncing an open file is not a good idea. If the file is a database you can end up with a totaly worthless bunch of random bits. :-( If the file is closed, then RSYNC will work, but it may not work for all database systems, check before using. If the record itself or the database has a creation/update timestamp using it would be better. Run a job at an interval that dumps the records using in restorable form to a flat file that have changed since the last sync, and restore them to the copy of the database. This minimizes the chance that either or both databases will get out of sync or become corrupted. Rsync will work perfectly fine for SAMBA mounts from Windows servers and it also runs under SFU and CygWin directly on Windows. There may also be a native Windows port. Note that a little clever programing can create a "shadow" database using a different access method. For example an SQL server accesed with ACCESS on the windows machines and a MySQL or Postgess data base on a Linux server. It would be best (if not required) to limit your updates to one of them. An example of this would be an order database that is filled and queried on a web server and then shadowed on Windows machines for the bean counters. Or the other way around, an exisiting Windows database can be shadowed for web (or internal) browser access. Geoff. -- Geoffrey S. Mendelson, Jerusalem, Israel [EMAIL PROTECTED] N3OWJ/4X1GM IL Voice: (07)-7424-1667 Fax ONLY: 972-2-648-1443 U.S. Voice: 1-215-821-1838 Visit my 'blog at http://geoffstechno.livejournal.com/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
