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
