Bacula-users

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

2011-11-06 17:41:40
Subject: Re: [Bacula-users] RE : HELP : MySQL database lost - how best to restore data
From: Jérôme Blion <jerome.blion AT free DOT fr>
To: bacula-users AT lists.sourceforge DOT net
Date: Sun, 06 Nov 2011 23:39:53 +0100
Le 06/11/2011 23:06, Win Htin a écrit :
> Hi folks,
>
> Thanks for the various suggestions. I found setting the variables
> export MYSQL_HOST=<database_hostname>
> export MYSQL_TCP_PORT=<port_number>
> export MYSQL_UNIX_PORT=<port_number>
> before running the "bscan" command did the trick.
> Now, have to see if my "bscan" will work.
>
> Thanks,
> Win
>
> On Sun, Nov 6, 2011 at 4:13 PM, Konstantin Khomoutov
> <flatworm AT users.sourceforge DOT net>  wrote:
>> On Sun, 6 Nov 2011 15:50:13 -0500
>> Win Htin<win.htin AT gmail DOT com>  wrote:
>>
>>> 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 I am
>>> in a bit of a bind. Any ideas?
>> Try environment variables listed at
>> http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html
>>
Hello,

By default, Bacula stores the catalog dump in /var/lib/bacula/
root@bckserver:/var/lib/bacula# ls -l /var/lib/bacula/bacula.sql
-rw------- 1 bacula bacula 1605037178  6 nov.  04:36 
/var/lib/bacula/bacula.sql

Perhaps it will be faster to recover from it ?

HTH.
Jerome Blion.

------------------------------------------------------------------------------
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