Live DB backups with rsync?

2003-01-14 Thread Steve Mallett
Is it possible to do live backups of a running DB with rsync???

I was just talking to livevault.com  they (only on win boxes) say they 
can grab changes from a client's live DB  sync them remotely.

It sounded like BS to me, but I'm neither a DB guy or sync'ing expert.

Steve Mallett

--
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html


error msg

2002-12-29 Thread Steve Mallett
Using this command:  rsync -azurvp /Users/spaceman/ -e ssh 
[EMAIL PROTECTED]:/home/test --timeout=60

wrote 2577422743 bytes  read 79546 bytes  448846.72 bytes/sec
total size is 2831489571  speedup is 1.10
rsync error: partial transfer (code 23) at 
/SourceCache/rsync/rsync-8/rsync/main.c(576)

It appears that I only get this error -after- files are sent.

Steve Mallett

--
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html


Re: rsync to 2000/NT servers?

2002-12-13 Thread Steve Mallett
Craig Barratt wrote:

Watch out for pagefile.sys (i think!)... it's won't copy. (let me know about 
any other's)


Most important files won't copy.  The registry files are locked and
can't be read by rsync/cygin (nor are they served by smb).

Similarly, the outlook.pst file used by Outlook (which contains all
the email, attachments, calendar and address book info of an outlook
user) is locked whenever outlook is open (which is most of the time).
Exchange databases, SQL databases will be locked too.  Any file open
by a windows app is likely locked too.

So you can get 99% of the files, but the 1% you miss are the most
critical.



Now, can you think of a way to sync the win 2000 OS? (the WHOLE flippin' 
system) so that if it were to go down one could restore the full installation
(bootstraps, bootloader, ect!!?) by means of the rsync'ed backup.
please? thank you. ;-)


I wish this was possible, but I don't know how to do this.
Commercial products use an OFM (open file manager) to allow
locked files to be accessed.  Products are sold by companies
like St. Bernard or Columbia Data Products.  Apparently Veritas and
Legato bundle this product with their commercial backup products.

See for example

http://www.stbernard.com/products/docs/ofm_whitepaperV8.pdf

What we need is an open source OFM that is compatible with rsync.
Then bare-metal WinXX recovery would be possible.

Craig



I'm thinking more along the lines of those files that someone wanted 
backed up being put in a file for a scheduled backup rather than ssh'ing 
in and getting them directly.

Steve Mallett

--
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html


rsync to 2000/NT servers?

2002-12-11 Thread Steve Mallett
I'm rsyncing over ssh to unix servers now  am wondering what people who 
use rsync for their unix boxes do when dealing with win 2000/NT machines?

Steve Mallett

--
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html


rsync over ssh - reporting errors

2002-11-21 Thread Steve Mallett
I have rsync using ssh to grab files off my local box, but would like 
to include some basic error reporting.

If the directory I'm trying to access no longer exists (or other 
reasons why the rsync would fail) I'd like to be notified vs. checking 
everyday.

So, for instance:

#!/bin/sh
rsync -azurv -e ssh [EMAIL PROTECTED]:/Users/spaceman/docs  .  #I 
changed docs to Docs for example
if [ $? -eq 1]
then mail -s backup failed spaceman
fi

The process fails, but just hangs and doesn't exit to mail the error 
msg.
Any suggestions?

Steve Mallett

--
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html