Hi, On 4/18/2007 10:37 PM, Ryan Novosielski wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Arno Lehmann wrote: >> Hi, >> >> On 4/18/2007 9:57 PM, Ryan Novosielski wrote: ... >>> Have you checked that the database is ok? > > I just did a mysqlcheck -A -- another backup is currently running, and > the only thing I got is many warnings:
Well, I don't know much about the internals of MySQL, but I don't think these warnings are serious. As long as the database is ok from MySQLs point of view, I think that should be ok. You might consider running dbcheck, but I really don't think this will find corrupt, but consistent volume records... > # ./mysqlcheck -A -u bacula -p ... > Only one backup is running right now, though, so would you expect this > is something to be concerned about? I could restore a catalog backup I > suppose -- one theoretically kicked off at the end of the last > successful backup. Unfortunately at this point, that would likely mean > redoing/bscanning the backup that's currently running (~25GB). Hmm. So it's one bscan vs. one bscan... difficult choice. >> What would you do next if you were me? Scrap the tape and do new >> backups? bscan? >> >>> Yup, bscan and compare with what the tape should hold according to the >>> catalog. > > The manual says (and I'm considering copying Kern on this, because this > ought to be corrected regardless of what the current state is): > > - --- > "Using bscan to Compare a Volume to an existing Catalog Ah, there is some misunderstanding... I would do that comparison manually, i.e. finding which jobs actually are on tape, and which should be, according to the catalog. If the first job on tape is what the catalog says it should be, bscan the tape. If it isn't, scratch it. And see if the job is known to the catalog... I wouldn't do a more detailed analysis - too much work for just seven backups :-) > If you wish to compare the contents of a Volume to an existing catalog > without changing the catalog, you can safely do so if and only if you do > not specify either the -m or the -s options. However, at this time > (Bacula version 1.26), the comparison routines are not as good or as > thorough as they should be, so we don't particularly recommend this mode > other than for testing." > - --- > > Has this been improved any, or should I still not really consider this > an option? > >> Thanks for your help! >> >>> Good luck... ok, if it's only one tape there is not much trouble :-) > > Not only just one tape, but furthermore only one night of backups (7 > incremental backups in all). Not really worth the trouble, except I > really should get myself an education in what to do for this type of > circumstance should I ever really need to know. Isn't that the reason why we all spend so much time thinking about problems, how to solve them, where to store bsrs of the catalog backups, etc? - Just to prepare for a moment that (hopefully) never happens, and if it does, it holds surprises nobody ever expected? > Thanks! > > - -- > ---- _ _ _ _ ___ _ _ _ > |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III > |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) > \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.5 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFGJoF1mb+gadEcsb4RAgOKAJwIO1Z1qbk5ktyHrS2UWbLTuDxDagCglIo9 > hufuW1XRWbiX5WDtnLqk2Ds= > =uEv8 > -----END PGP SIGNATURE----- > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
