On Fri, Mar 30, 2007 at 10:28:56PM -0400, AltGrendel wrote: > I'm running bacula-mysql-2.0.1-1 on Fedora core 6. Last week the /var > partition filled up, corrupting the bacula database. Using the advice of > Frank Sweetser (thanks again, Frank), I've repaired the tables and have > made a backup of the database. Now I have the problem in that none of > the backup jobs are showing up in bconsole, even though I've verified > that the data is there. > > The section of the bacula documentation that explains about catalog > maintaince mentions reindexing the Filename and Path tables.
Doing the repair tables should have recreated any indexes. It's worth nothing that doing a repair will simply guarantee that the contents of the tables are well formed - it's still quite possible that data were lost. The next step to try would be to run dbcheck to check a number of possible data holes. If that finds chunks of orphaned records, the only way to fill them in would be to dbscan the tapes into the catalog. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users