for backing up MySQL databases, why not run a second MySQL and sync them on
a schedule? Then if you have a problem you dont even need to restore, you
can just switch to the other server or restart the first machine and sync
the other way? If you do this you can sync, then stop the backup so you can
dump that to disk/tape/etc etc.
Thoughts?
On Fri, Oct 10, 2008 at 2:26 AM, Paul Bijnens
<[EMAIL PROTECTED]>wrote:
>
> On 2008-10-09 22:13, Nick Smith wrote:
> > On Thu, Oct 9, 2008 at 3:38 PM, David Rees <[EMAIL PROTECTED]> wrote:
> > >
> > > As long as the file names remain the same and you are using rsync,
> > > only the changes will be downloaded.
> > >
> > Do you know how it does that? I thought it just checked checksums to
> > see if they were different? How can it just download the changes to a
> > large DB like that if its all contained in a single file DB?
>
> That is the virtue of the rsync algorithm.
> See: http://en.wikipedia.org/wiki/Rsync
>
>
> --
> Paul Bijnens, xplanation Technology Services Tel +32 16 397.511
> Technologielaan 21 bus 2, B-3001 Leuven, BELGIUM Fax +32 16 397.512
> http://www.xplanation.com/ email: [EMAIL PROTECTED]
> ***********************************************************************
> * I think I've got the hang of it now: exit, ^D, ^C, ^\, ^Z, ^Q, ^^, *
> * F6, quit, ZZ, :q, :q!, M-Z, ^X^C, logoff, logout, close, bye, /bye, *
> * stop, end, F3, ~., ^]c, +++ ATH, disconnect, halt, abort, hangup, *
> * PF4, F20, ^X^X, :D::D, KJOB, F14-f-e, F8-e, kill -1 $$, shutdown, *
> * init 0, kill -9 1, Alt-F4, Ctrl-Alt-Del, AltGr-NumLock, Stop-A, ... *
> * ... "Are you sure?" ... YES ... Phew ... I'm out *
> ***********************************************************************
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> BackupPC-users mailing list
> [email protected]
> List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
> Wiki: http://backuppc.wiki.sourceforge.net
> Project: http://backuppc.sourceforge.net/
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
BackupPC-users mailing list
[email protected]
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
