Have you tried restoring files from your live backups?!? It's probably not a bright idea to back up live databases; there's no guarantee of data consistency--it might work 99 out of 100 times, but Murphy works nights, weekends, and holidays.
Exclude the live db files from your backup. Schedule a cron job to dump the databases to another directory (you can do this with no downtime), then have backuppc backup those dump files during its normal run. You can also configure backuppc to do the dump as a DumpPreUserCmd script, but I find it easier to just use cron... To keep Murphy at bay, test your setup by making sure you know how to import the dump files back into mysql. Cheers, Stephen -- Stephen Joyce Systems Administrator P A N I C Physics & Astronomy Department Physics & Astronomy University of North Carolina at Chapel Hill Network Infrastructure voice: (919) 962-7214 and Computing fax: (919) 962-0480 http://www.panic.unc.edu "Lazy Programmers know that if a thing is worth doing, it's worth doing well -- unless doing it well takes so long that isn't worth doing any more. Then you just do it 'good enough'" --- Programming Perl, p 282. On Tue, 25 Mar 2008, WebIntellects Technical Support wrote: > Hello, > We haven't had any problems with backuppc until recently. We are getting > the following error on a few new servers that we have added. > > full backup started for directory /var/www > Running: /usr/bin/ssh -l bupc admin.DOMAIN.com sudo /usr/bin/rsync --server > --sender --numeric-ids --perms --owner --group --devices --links --times > --block-size=2048 --recursive --ignore-times . /var/www/ > Xfer PIDs are now 11710 > Got remote protocol 29 > Negotiated protocol version 28 > Sent exclude: /var/qmail/queue > Xfer PIDs are now 11710,12192 > [ skipped 81249 lines ] > Done: 77925 files, 5453948779 bytes > full backup started for directory /var/lib/mysql > Running: /usr/bin/ssh -l bupc admin.DOMAIN.com sudo /usr/bin/rsync --server > --sender --numeric-ids --perms --owner --group --devices --links --times > --block-size=2048 --recursive --ignore-times . /var/lib/mysql/ > Xfer PIDs are now 12716 > Got remote protocol 29 > Negotiated protocol version 28 > Sent exclude: /var/qmail/queue > fileListReceive() failed > Done: 0 files, 0 bytes > Got fatal error during xfer (fileListReceive failed) > Backup aborted (fileListReceive failed) > > The backuppc connects just fine and starts to download the files. You > can see this under the first rsync command for /var/www, however, once > the rsync process gets to the /var/lib/mysql directory the backup fails > everytime. I then shut down mysql on the server and run the backup and > it funs fine. Is anybody aware of this issue? Is there a fix? We are > able to backup live mysql directories on other servers, just not on the > new Centos 5 servers. Any insight into this problem is greatly > appreciated. As you know shutting down mysql to do backups isn't a very > good option. Thanks in advance! > > -- > ---------------------------------------- > Josh Elson > WebIntellects Technical Support > [EMAIL PROTECTED] > 800-994-6364 > 760-477-1100 > http://cm.controlmaestro.com > ---------------------------------------- > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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/
