Bacula-users

[Bacula-users] RE : HELP : MySQL database lost - how best to restore data

2011-11-07 19:02:10
Subject: [Bacula-users] RE : HELP : MySQL database lost - how best to restore data
From: Win Htin <win.htin AT gmail DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 7 Nov 2011 19:00:39 -0500
> Message: 12
> Date: Sun, 06 Nov 2011 14:04:08 -0500
> From: Phil Stracchino <alaric AT metrocast DOT net>
> Subject: Re: [Bacula-users] HELP : MySQL database lost - how best to
>        restore data
> To: bacula-users AT lists.sourceforge DOT net
> Message-ID: <4EB6DA28.8010207 AT metrocast DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] RE : HELP : MySQL database lost - how best to restore data, Win Htin <=