Hi All, Kern is right... I should have never changed those MediaIds... I actually remember changing a few other things such as renaming the Default pool to Weekly and resetting the auto_increment value on Media and Pool tables. I also remember changing something about PoolId. In hind-sight, I don't know what I was thinking (probably just being too picky as always)... It sounds like I hosed my database. I am so worried about this... Is there anyway to restore my database? Btw, these changes were made when I originally setup bacula... So, I cannot just restore the database from a previous dumpfile... The only way that I can forsee restoring the database is to do the following:
1) backup the current database to a dumpfile 2) drop the current database 3) recreate the database using the initial bacula sql scripts provided with the distribution 4) bscan in all of my tapes ... Am I wrong? I hope so, because this sounds like a grueling process... Basically, is there a better way to fix my database, such as using some sql-hackery? My setup is: MySQL 4.1.20-1 Bacula 2.0.1 (Current Pools=Weekly, Scratch, Migrate, Archive) RHEL 4 AS Regards, Mike Kern Sibbald wrote: > On Thursday 15 March 2007 04:38, [EMAIL PROTECTED] wrote: > >> Upon running a migration job, bacula asked me to load one of my >> cleaning tapes... Then, I updated the MediaId in the Media table to >> correspond with the tape that bacula should have been looking for... >> This caused bacula to successfully complete the migration job...I think >> bacula should have been looking for a specific VolumeName *not* >> MediaId... I like bacula, but this is just wrong... Btw, this problem >> occured because I changed some of my MediaIds a while back (I can't >> help it sql is fun and I'm a control freak :-D)... But still, i think >> bacula should have asked me to load tape "MSR100L3" or whatever... Ya >> know? >> > > If you modified a MediaId in the Media table and you don't understand the > full > details of how the database is organized and linked together (e.g. where to > find *all* references to the MediaId), you have probably damaged your > database. > > While certain fields can be modified directly via SQL, MediaIds are not one. > For the record, I discourage all users from doing similar things, and I can > assure you, it is not something that I would personally do. > > To the best of my knowledge the only place Bacula ever asks for a MediaId is > when it asks you to select a particular Volume during the update command (and > possibly some other ones). > > If you decide to respond to this with a bit more concrete information, please > read the Support page on the bacula web site (www.bacula.org -> Support) > first. > > ------------------------------------------------------------------------- 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
