|
Re: [BackupPC-users] backing up large SQL DB's
2008-10-11 14:20:44
Another way to do this is get a Windows
type box, use MySqlAdmin on the windows box (Free perdy GUI download J ) and have it schedule
the backups. The backups end up as TXT files that compress wonderfully, and
restore perfectly.
~Seann
From: dan
[mailto:dandenson AT gmail DOT com]
Sent: Friday, October 10, 2008
9:27 PM
To: General list for user
discussion,questions and support
Subject: Re: [BackupPC-users]
backing up large SQL DB's
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 <Paul.Bijnens AT xplanation DOT com>
wrote:
On 2008-10-09 22:13, Nick Smith wrote:
> On Thu, Oct 9, 2008 at 3:38 PM, David Rees <drees76 AT gmail DOT com> 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: Paul.Bijnens AT xplanation DOT com
***********************************************************************
* 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
BackupPC-users AT lists.sourceforge DOT net
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
|
|
|
