[BackupPC-users] Server reboots nightly
Almost every morning, I come into the server room and find that my BackupPC server has been rebooted. I log it in and leave it logged in every day. When I get back in the morning, the login screen is there. Does anyone have any explanations as to why? We are running on Fedora Core 9. We are not running the latest kernel because when I last tried a kernel upgrade, our external hard drive no longer worked after the upgrade. Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -Original Message- From: Joe Bordes [mailto:j...@tsolucio.com] Sent: Monday, January 05, 2009 5:00 PM To: General list for user discussion,questions and support Subject: Re: [BackupPC-users] Backing up over the Internet Hi, You could try noip.com services, open a couple of rsync ports on your router and configure BackupPC to use them. Joe TSolucio Jeremy H. Griffith escribió: Hi all! I have a small LAN in Hillsboro, OR, which is connected to the Net though a (NAT) router provided by Verizon. The IP on the Net side is variable. My backup server is in Los Angeles, and has its own static IP. It's a dedicated server, using FreeBSD, and I had no problem with backuppc setup on it. How can I tell backuppc to access systems on my LAN? I'd like to back up two hosts on it, one Vista Home (my wife's), the other Win2K Pro. I'll probably add a Linux one for development soon too. I suspect I need to set up a VPN; if so, what VPN software do you recommend? Or can the LAN systems log in to backuppc over the Net to start the process? Or is this beyond backuppc's area? In that case, what other software might do the job? I'm a C++ programmer, but my perl skills are, ahem, rudimentary. Thanks! -- Jeremy H. Griffith, at Omni Systems Inc. jer...@omsys.com http://www.omsys.com/ -- ___ 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 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/ -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] 38GB file backup is hanging backuppc.
Hi all: Having a problem with backuppc running over ssh with rsync. I am backing up a 38GB file daily (database dump). There were some changes on the database server, so I started a new full dump. After two days (40+ hours) it had still not completed. This is over a GB network link. I restarted the full dump thinking it had gotten hung. I tried to find the partly written file on the backup server, and found some very odd things. The BackupPC_dump perl process (pid 16784) is showing this sequence in strace: alarm(172800) = 172800 select(16, [11], NULL, [11], NULL) = 1 (in [11]) read(11, BjGq8Ax1SfiCcrVqaRuPzV5js\n /c3By..., 65536) = 8188 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 select(16, [11], NULL, [11], NULL) = 1 (in [11]) read(11, \374\17\0\7tQsU3/6Vsd/9z\n 5/k/8AH6xrT/X..., 65536) = 12288 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 select(16, [11], NULL, [11], NULL) = 1 (in [11]) read(11, \374\17\0\7HvnkYehOv7k\n Dz+T/vuo5EevevG..., 65536) = 12288 alarm(172800) = 172800 alarm(172800) = 172800 alarm(172800) = 172800 lsof on that process shows the following file descriptors: BackupPC_ 16784 backup0w CHR1,3 1937 /dev/null BackupPC_ 16784 backup1w FIFO0,6 846787883 pipe BackupPC_ 16784 backup2w FIFO0,6 846787883 pipe BackupPC_ 16784 backup3u IPv4 846787907 TCP backup:59406-ldap:ldaps(ESTABLISHED) BackupPC_ 16784 backup4w REG9,22171 47693861 /backup-pc/pc/ldap01.bos1.renesys.com/LOG.022009 BackupPC_ 16784 backup5w REG9,2 0 47695023 /backup-pc/pc/ldap01.bos1.renesys.com/XferLOG.z BackupPC_ 16784 backup6w REG9,22228 47695267 /backup-pc/pc/ldap01.bos1.renesys.com/NewFileList BackupPC_ 16784 backup7w REG9,2 8634251394 36864007 /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/ffedora-ds/fcurrent/fuserRoot/fid2entry.db4 BackupPC_ 16784 backup8u REG9,2 37303115776 34717713 /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/RStmp BackupPC_ 16784 backup9u unix 0xf6f12c80 846791450 socket BackupPC_ 16784 backup 11u unix 0xf6835c80 846791422 socket ls -l of the file on file descriptor 7: -rw-r- 1 backup dev 8634251394 Feb 6 15:10 /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/ffedora-ds/fcurrent/fuserRoot/fid2entry.db4 while the one on fd 8 shows: -rw-r- 1 backup dev 37303115776 Feb 5 18:34 /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/RStmp What is the RStmp file? That one grew pretty quickly to it's current size given the start time of the backup (18:08 on feb 5). If I run file (1) against that file it identifies it as /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/RStmp: Berkeley DB (Btree, version 9, native byte-order) While file on the fid2entry.db4 file shows: /backup-pc/pc/ldap01.bos1.renesys.com/new/f%2fdata%2fbak/ffedora-ds/fcurrent/fuserRoot/fid2entry.db4: data I could almost believ that I looking at the actual rsynced data file (in RStmp) which is a little shorter than the source file possibly due to sparse file compression or something that makes it a bit shorter by suppressing blocks of nulls? But running a cmp -l between the source file and the RStmp file shows differences before the end of the RStmp file. The backup server has 8GB of memory available, is almost 100% idle and I am seeing no I/O wait in top. I don't see the perl/BackupPC_dump process showing up in the top output either. The server is running centos 5.2 on an ext3 filesystem. The rsync on the host being backed up looks like: write(1, \374\17\0\7, 4) = 4 select(2, NULL, [1], [1], {60, 0}) = 1 (out [1], left {60, 0}) write(1, fLv/BPD4v6neeJr74fazcy31hf2r3em..., 4092) = 4092 select(2, NULL, [1], [1], {60, 0}) = 1 (out [1], left {60, 0}) write(1, \374\17\0\7, 4) = 4 select(2, NULL, [1], [1], {60, 0}) = 1 (out [1], left {60, 0}) write(1, \266.\27\0\1\0\346\37\0\7dn: nsuniqueid=4ed5424..., 4092) = 4092 select(2, NULL, [1], [1], {60, 0}) = 1 (out [1], left {60, 0}) write(1, \374\17\0\7, 4) = 4 select(2, NULL, [1], [1], {60, 0}) = 1 (out [1], left {60, 0}) write(1, DkmvilSqKpyWd+x9aqkHHmjJHg3x28V/..., 4092) = 4092 select(2, NULL, [1], [1], {60, 0}) = 0 (Timeout)
Re: [BackupPC-users] Server reboots nightly
Not to be simplistic, but have you checked the server's logs? PS. It's best to compose a new message rather than just change the subject in an existing thread. On Fri, 6 Feb 2009, Chris Baker wrote: Almost every morning, I come into the server room and find that my BackupPC server has been rebooted. I log it in and leave it logged in every day. When I get back in the morning, the login screen is there. Does anyone have any explanations as to why? We are running on Fedora Core 9. We are not running the latest kernel because when I last tried a kernel upgrade, our external hard drive no longer worked after the upgrade. Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -Original Message- From: Joe Bordes [mailto:j...@tsolucio.com] Sent: Monday, January 05, 2009 5:00 PM To: General list for user discussion,questions and support Subject: Re: [BackupPC-users] Backing up over the Internet [remainder of thread truncated for brevity] -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Server reboots nightly
Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -Original Message- From: Stephen Joyce [mailto:step...@physics.unc.edu] Sent: Friday, February 06, 2009 9:46 AM To: General list for user discussion,questions and support Which logs should I check? And what should I look for in these logs? I do know where the logs are on the system. Subject: Re: [BackupPC-users] Server reboots nightly Not to be simplistic, but have you checked the server's logs? PS. It's best to compose a new message rather than just change the subject in an existing thread. On Fri, 6 Feb 2009, Chris Baker wrote: Almost every morning, I come into the server room and find that my BackupPC server has been rebooted. I log it in and leave it logged in every day. When I get back in the morning, the login screen is there. Does anyone have any explanations as to why? We are running on Fedora Core 9. We are not running the latest kernel because when I last tried a kernel upgrade, our external hard drive no longer worked after the upgrade. Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] 38GB file backup is hanging backuppc.
On Fri, Feb 06, 2009 at 08:04:57AM -0800, Michael L. Barrow wrote in a non-list copied email: In my experience, rsync doesn't play nice with really big files for incremental updates. I recommend that you have a unique filename so that you basically end up with a full backup each time around. In this problem I am backing up on the same lan, in production it will be backed up offsite across a slow wan, so compression and rsync algorithms will be key. It was working well enough before the last major database change, so I concur that large difference in a large file appear to be causing issues, but it looks like the problem is on the backuppc end. Hmm, maybe if I change the rsync command for that host to include --whole-file I can get a new baseline. Does anybody know if the rsync perl library used by BackupPC can handle whole-file mode? Usually the incremental changes between the files are under 100MB of the 36GB file which makes doing daily backups possible. Using just plain rsync (2.x) on both sides across the wan works fine and results in a huge speedup. But thanks for the caution. That gives me another avenue to test at least although it may result in having to dump backupc. -- -- rouilj John Rouillard System Administrator Renesys Corporation 603-244-9084 (cell) 603-643-9300 x 111 -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] protocol negotiation failed
I've got one Vista server that's sending back a strange smb error: protocol negotiation failed I've tried turning the local firewall off with the same result. SMB version is 3.0.23. Thoughts? Thanks. Matt -- -- Matthew Vogt | ITS - Windows Systems Administrator Fuller Theological Seminary 626-396-6060 office | 626-396-6023 fax mattv...@fuller.edu -- -- -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ 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] Setting UP the CGI Interface
Odhiambo Washington wrote: Hello list, I am new but I am kind of old hand. Haven't seen you on the Squid-Users list in a while... :o) Surprisingly, I am not able to get the CGI interface to show up things as beautifully as I see in the screenshots on the website and I wonder what I am missing. My BackupPC_Admin is in /usr/local/www/apache22/cgi-bin/ and it is owned by backuppc:www. The images from BackupPC are in /usr/local/www/apache22/icons/BackupPC In config.pl, I have the following: $Conf{ServerHost} = 'gw.crownkenya.com http://gw.crownkenya.com'; $Conf{CgiDir} = '/usr/local/www/apache22/cgi-bin'; $Conf{CgiImageDir}= '/usr/local/www/apache22/icons/BackupPC'; $Conf{CgiImageDirURL} = '/BackupPC'; Going to http://$Conf{ServerHost}/BackupPC/ displays all the images. I could have the images inside /usr/local/www/apache22/icons/ but even that did not work! Is there someone who encountered such a problem and managed to solve it?? When I surf to http://gw.crownkenya.com/cgi-bin/BackupPC_Admin, things look fine... Are you trying a different URL? - Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood Chris -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Server reboots nightly
Chris Baker wrote: Which logs should I check? /var/log/messages And what should I look for in these logs? Run the command dmesg (first, man dmesg so you know what this command does) and take a look at the output. This is the bootup message and should be replicated in /var/log/messages. Take a look at the entries above for clues as to why your server is restarting. The last log entry before the dmesg output should be something along the lines of Kernel log daemon terminating. and should be proceeded by evidence of exiting processes. If not, you probably have power or hardware problems. If you do see evidence of a graceful restart, at least you know about when it's happening. Start looking through /etc/cron.* and /etc/crontab for jobs that run around that time. I do know where the logs are on the system. Chris -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Server reboots nightly
check any log files you find in /var/log too! messages is a good one to start with, but depending on the exact configuration, you might find other log files there too. Chris Robertson wrote: Chris Baker wrote: Which logs should I check? /var/log/messages And what should I look for in these logs? Run the command dmesg (first, man dmesg so you know what this command does) and take a look at the output. This is the bootup message and should be replicated in /var/log/messages. Take a look at the entries above for clues as to why your server is restarting. The last log entry before the dmesg output should be something along the lines of Kernel log daemon terminating. and should be proceeded by evidence of exiting processes. If not, you probably have power or hardware problems. If you do see evidence of a graceful restart, at least you know about when it's happening. Start looking through /etc/cron.* and /etc/crontab for jobs that run around that time. I do know where the logs are on the system. Chris -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/ -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Server reboots nightly
That was a great answer. The server is rebooting every morning at 7:00. I will see what I can find out from that. Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -Original Message- From: Chris Robertson [mailto:crobert...@gci.net] Sent: Friday, February 06, 2009 2:58 PM To: General list for user discussion, questions and support Subject: Re: [BackupPC-users] Server reboots nightly Chris Baker wrote: Which logs should I check? /var/log/messages And what should I look for in these logs? Run the command dmesg (first, man dmesg so you know what this command does) and take a look at the output. This is the bootup message and should be replicated in /var/log/messages. Take a look at the entries above for clues as to why your server is restarting. The last log entry before the dmesg output should be something along the lines of Kernel log daemon terminating. and should be proceeded by evidence of exiting processes. If not, you probably have power or hardware problems. If you do see evidence of a graceful restart, at least you know about when it's happening. Start looking through /etc/cron.* and /etc/crontab for jobs that run around that time. I do know where the logs are on the system. Chris -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/ -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Server reboots nightly
hi, Check the BIOS for auto stop/start times or awake on lan settings. Mark Chris Baker wrote: That was a great answer. The server is rebooting every morning at 7:00. I will see what I can find out from that. Chris Baker -- cba...@intera.com systems administrator INTERA -- 512-425-2006 -Original Message- From: Chris Robertson [mailto:crobert...@gci.net] Sent: Friday, February 06, 2009 2:58 PM To: General list for user discussion, questions and support Subject: Re: [BackupPC-users] Server reboots nightly Chris Baker wrote: Which logs should I check? /var/log/messages And what should I look for in these logs? Run the command dmesg (first, man dmesg so you know what this command does) and take a look at the output. This is the bootup message and should be replicated in /var/log/messages. Take a look at the entries above for clues as to why your server is restarting. The last log entry before the dmesg output should be something along the lines of Kernel log daemon terminating. and should be proceeded by evidence of exiting processes. If not, you probably have power or hardware problems. If you do see evidence of a graceful restart, at least you know about when it's happening. Start looking through /etc/cron.* and /etc/crontab for jobs that run around that time. I do know where the logs are on the system. Chris -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/ -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/ -- Mark Maciolek Network Administrator Morse Hall 339 862-3050 m...@sr.unh.edu https://www.sr.unh.edu -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] Is a switch between different transfer methods possible?
I use rsyncd to backup my (Windows) clients. The first backup of each client needs a really long time. Would it be faster if I use smb or tar for the initial backup? Is it possible to switch back to rsyncd after this initial backup? Would I maintained all the benefits of rsyncd starting with the 2nd backup? Thanks Matthias -- Don't Panic -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] how does backuppc handle DBs
On Fri, Feb 6, 2009 at 9:09 PM, Nick Smith nick.smit...@gmail.com wrote: I have a couple clients backup nightly over the internet. I seem to be doubting if the backups are actually being completed successfully. Backuppc tells me they are, but the reason im questioning is because it is suppose to backup 10gigs a night (their sql db changes daily) and backup completes in 40mins over a max connection of 600kb. The backup results do say its getting about 50% compression and the backup is only 5gigs when it complete. How does backuppc handle databases? does it take just whats changed or if the DB changes does it have to backup the entire thing again? ive gotten 14 complete full backups (one a day) and they all have the same results completed successfully and are about 10gigs before compression and pooling. its there a way i can make sure that things are working as planned? i mean without doing a restore and testing what its backing up. i just dont want to think im getting good backups when im really not. im using scripts that use volume shadow to get backups of their windows servers after hours. it just seems like the backups are going way to fast with the speed of the connection and the size of the data. thanks for any light you can shed on the subject. and to add to my own post im doing these backups over a pfsense firewall on both sides and the stats for the last 4 hours (when the 10gig backup was supposedly preformed), the output transmitted on the WAN was only 50megs. so something isnt working correctly here. -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] how does backuppc handle DBs
I have a couple clients backup nightly over the internet. I seem to be doubting if the backups are actually being completed successfully. Backuppc tells me they are, but the reason im questioning is because it is suppose to backup 10gigs a night (their sql db changes daily) and backup completes in 40mins over a max connection of 600kb. The backup results do say its getting about 50% compression and the backup is only 5gigs when it complete. How does backuppc handle databases? does it take just whats changed or if the DB changes does it have to backup the entire thing again? ive gotten 14 complete full backups (one a day) and they all have the same results completed successfully and are about 10gigs before compression and pooling. its there a way i can make sure that things are working as planned? i mean without doing a restore and testing what its backing up. i just dont want to think im getting good backups when im really not. im using scripts that use volume shadow to get backups of their windows servers after hours. it just seems like the backups are going way to fast with the speed of the connection and the size of the data. thanks for any light you can shed on the subject. -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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] how does backuppc handle DBs
I make my mysql servers dump their DB's to a file before running BackupPC. Quoting Nick Smith nick.smit...@gmail.com: On Fri, Feb 6, 2009 at 9:09 PM, Nick Smith nick.smit...@gmail.com wrote: I have a couple clients backup nightly over the internet. I seem to be doubting if the backups are actually being completed successfully. Backuppc tells me they are, but the reason im questioning is because it is suppose to backup 10gigs a night (their sql db changes daily) and backup completes in 40mins over a max connection of 600kb. The backup results do say its getting about 50% compression and the backup is only 5gigs when it complete. How does backuppc handle databases? does it take just whats changed or if the DB changes does it have to backup the entire thing again? ive gotten 14 complete full backups (one a day) and they all have the same results completed successfully and are about 10gigs before compression and pooling. its there a way i can make sure that things are working as planned? i mean without doing a restore and testing what its backing up. i just dont want to think im getting good backups when im really not. im using scripts that use volume shadow to get backups of their windows servers after hours. it just seems like the backups are going way to fast with the speed of the connection and the size of the data. thanks for any light you can shed on the subject. and to add to my own post im doing these backups over a pfsense firewall on both sides and the stats for the last 4 hours (when the 10gig backup was supposedly preformed), the output transmitted on the WAN was only 50megs. so something isnt working correctly here. -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/ -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ 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/