Re: [BackupPC-users] backing up large SQL DB's
If you run a second MySQL, why not configure it as a replicated slave? Works well for us. Philip J. Tait http://subarutelescope.org On Fri, 2008-10-10 at 20:27 -0600, dan wrote: > 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 ServicesTel +32 > 16 397.511 > Technologielaan 21 bus 2, B-3001 Leuven, BELGIUMFax +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 > BackupPC-users@lists.sourceforge.net > 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 > BackupPC-users@lists.sourceforge.net 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 BackupPC-users@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] Almost working
When I started this transition, Fedora 8 was issued and stable. When I am more stable with Linux, I'll be willing to be more adventurous. -- ken -Original Message- From: Michael Mansour [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2008 11:23 PM To: General list for user discussion,questions and support; BackupPC-users@lists.sourceforge.net Subject: Re: [BackupPC-users] Almost working Hi, > Hello all, > > For a number of years I have run a small home network of windows machines. > I recently decided to move my computing to Linux. I now have two machines > running Fedora 8. The first machine assumed the role of my windows server Why choose Fedora 8 and not Fedora 9? Fedora 8 has an End of Life next month: http://poelstra.fedorapeople.org/schedules/f-10/f-10-all-tasks.html No more support for it after that. Regards, Michael. - 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@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] Almost working
Hi, > Hello all, > > For a number of years I have run a small home network of windows machines. > I recently decided to move my computing to Linux. I now have two machines > running Fedora 8. The first machine assumed the role of my windows server Why choose Fedora 8 and not Fedora 9? Fedora 8 has an End of Life next month: http://poelstra.fedorapeople.org/schedules/f-10/f-10-all-tasks.html No more support for it after that. Regards, Michael. - 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@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
[BackupPC-users] Almost working
Hello all, For a number of years I have run a small home network of windows machines. I recently decided to move my computing to Linux. I now have two machines running Fedora 8. The first machine assumed the role of my windows server using samba. The second machine is to be my system archiving unit and I am initially trying to get BackupPC to maintain an archive of the windows shares on the first Linux box. I ultimately want to run 'rsync' as my transfer method, but was advised to use 'smb' when starting out since it would be simpler to set up. I am still quite a novice at Linux but this undertaking is quickly educating me. I have ssh running and can log into the other Linux machine and perform CLI operations in both directions. I have set up ssl and can connect from either machine to the other using https:// 'hostname'/ getting the default Apache html page. On the archiving unit, I can use https:// 'hostname'/BackupPC/ to open the BackupPC GUI. I cannot bring up the BackupPC GUI from the windows server machine but get a 403 screen - access not authorized. BackupPC is running and trying to perform the defined schedule but consistently fails with the message "tree connect failed: NT_STATUS_BAD_NETWORK_NAME". Since the problem appears to be with BackupPC getting a valid connection to the shares, I manually connected via smbclient: [EMAIL PROTECTED] ~]$ smbclient '\\winserver\share#1' -U 'uid' Password: Domain=[winserver] OS=[Unix] Server=[Samba 3.0.32-0.fc8] smb: \> ls . D 0 Mon Oct 6 09:02:18 2008 .. D 0 Sun Oct 5 22:11:07 2008 lost+foundD0 Mon Mar 31 12:45:23 2008 > files deleted for brevity < Linux Firewalls Using iptables.doc A 252416 Sun Oct 5 19:09:10 2008 55384 blocks of size 1048576. 46808 blocks available smb: \> I am using a 'per PC' setup file for the windows server defining all machine specific directives leaving config.pl to define only the common settings. In the $host file, I have tried various forms of how I specified the shares: '\\servername\sharename', '//servername/sharename', 'sharename', etc. All get the same result. All machines on the network are running with static IP addresses and nmblookup consistently finds them all by either hostname or IP address. Any comment or suggestion would be appreciated. -- ken - 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@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
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 <[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 ServicesTel +32 16 397.511 > Technologielaan 21 bus 2, B-3001 Leuven, BELGIUMFax +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 > BackupPC-users@lists.sourceforge.net > 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 BackupPC-users@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] Compression during Xfer
rsync does provide compression. rsync -z is compressed. just put this either in your main config or in the specific hosts config for the rsync command. ssh can compress the ssh tunnel that you create. you can also compress ipsec tunnels like openvpn or cisco vpn. Backup cant recognize it. The compression is in the transport stream, not the backup. You litterally wont be able to tell the difference in the backuppc backup. On Fri, Oct 10, 2008 at 4:06 AM, Tomasz Chmielewski <[EMAIL PROTECTED]> wrote: > Sebastien Sans schrieb: > > Hello, > > > > The compression system of the pool in BackupPc is great, it save a lot > > of place, but I didn't found how to compress the tranfers in order to > > save my bandwidth. > > I tryed to modify the command line in "rzync" and "tar" modes to > > activate compression (i added -z options to use gz compression), the > > transfer was shorter but the result was'nt well recognized by > > BackupPc. > > I'm sure there is a simple way to compress the tranferts. If someone > > has the solution, that would be great. > > Unfortunately, BackupPC does not support any sort of "transfer > compression". > > The best you can do is: > - do rsync transfers over SSH - SSH provides compression > - use VPN with compression, i.e. OpenVPN > > > -- > Tomasz Chmielewski > http://wpkg.org > > > - > 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@lists.sourceforge.net > 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 BackupPC-users@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] Script for managing mdadm add/removes
Thanks for the udev pointers everone - had a hectic work week with an even more crazy one coming up, but I'll see if I can't sneak in some time over the week for a first jab at it. Will let post back how it goes Regards, Kim Pedersen dan wrote: yes, UDEV can do an action for a device by UUID or serial number or label etc etc. On Wed, Oct 8, 2008 at 11:42 AM, Nils Breunese (Lemonbit) <[EMAIL PROTECTED]> wrote: Rob Owens wrote: > dan wrote: >> Your best bet here is to use udev rule for the device >> > > Careful! This will sync *any* drive that you plug in, won't it? Or > is > there a way to have a udev rule that applies to only a drive with a > specific UUID? I believe it's possible to have udev rules for specific devices, yes. Nils Breunese. - 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@lists.sourceforge.net 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 BackupPC-users@lists.sourceforge.net 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 BackupPC-users@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] Compression during Xfer
Sebastien Sans schrieb: > Hello, > > The compression system of the pool in BackupPc is great, it save a lot > of place, but I didn't found how to compress the tranfers in order to > save my bandwidth. > I tryed to modify the command line in "rzync" and "tar" modes to > activate compression (i added -z options to use gz compression), the > transfer was shorter but the result was'nt well recognized by > BackupPc. > I'm sure there is a simple way to compress the tranferts. If someone > has the solution, that would be great. Unfortunately, BackupPC does not support any sort of "transfer compression". The best you can do is: - do rsync transfers over SSH - SSH provides compression - use VPN with compression, i.e. OpenVPN -- Tomasz Chmielewski http://wpkg.org - 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@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
[BackupPC-users] Compression during Xfer
Hello, The compression system of the pool in BackupPc is great, it save a lot of place, but I didn't found how to compress the tranfers in order to save my bandwidth. I tryed to modify the command line in "rzync" and "tar" modes to activate compression (i added -z options to use gz compression), the transfer was shorter but the result was'nt well recognized by BackupPc. I'm sure there is a simple way to compress the tranferts. If someone has the solution, that would be great. Cordially, Ps: Sorry for my bad english, I tryed to do my best... - 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@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
Re: [BackupPC-users] backing up large SQL DB's
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 ServicesTel +32 16 397.511 Technologielaan 21 bus 2, B-3001 Leuven, BELGIUMFax +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 BackupPC-users@lists.sourceforge.net List:https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki:http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
