> Message: 12 > Date: Sun, 06 Nov 2011 14:04:08 -0500 > From: Phil Stracchino <ala...@metrocast.net> > Subject: Re: [Bacula-users] HELP : MySQL database lost - how best to > restore data > To: bacula-users@lists.sourceforge.net > Message-ID: <4eb6da28.8010...@metrocast.net> > Content-Type: text/plain; charset=ISO-8859-1 > > On 11/06/11 13:55, Win Htin wrote: >> Hi folks, >> >> If the bacula database is completely blown away but I still have the >> bootstrap file (*.bsr) what is the best method to re-install the >> bacula database? I think "bscan" is the way to go but am a bit >> confused with the explanations in the howto guide. The bare database >> has been re-created and I can get to the "bconsole" but of course >> commands like "update" or "list" will come back empty. > > Win, > What were you doing for MySQL catalog backup?
I believe the catalog was backed up on a daily basis but both partitions where the actual databases reside and the db dumps are kept got blown away. Don't ask me how since I do not know the details either. >> To make matters worse, the MySQL database is running on a none default >> port. Since "bscan" doesn't have an option to set the port number > > It doesn't...? > > Network backup, recovery and verification BSCAN(8) > > NAME > bscan - Bacula's 'Scan tape' > > ... > -t port > Specify database port (default: 0) Perhaps version 5.0.2 is missing that option or I overlooked in my haste. Thanks everyone. Need to get back to the "bscan" now. ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users