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

2011-11-07 Thread Win Htin
> Message: 12 > Date: Sun, 06 Nov 2011 14:04:08 -0500 > From: Phil Stracchino > 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

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

2011-11-06 Thread Phil Stracchino
On 11/06/11 15:50, Win Htin 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 It doesn't...? Network backup, recovery and verificationBSCAN(8) NAME bscan - Bacula's 'Scan tap

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

2011-11-06 Thread Konstantin Khomoutov
On Sun, Nov 06, 2011 at 11:39:53PM +0100, Jérôme Blion wrote: [...] > 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 Could you ple

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

2011-11-06 Thread Jérôme Blion
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= > export MYSQL_TCP_PORT= > export MYSQL_UNIX_PORT= > before running the "bscan" command did the trick. > Now, have to see if my "bscan" will work. > > Thank

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

2011-11-06 Thread Win Htin
Hi folks, Thanks for the various suggestions. I found setting the variables export MYSQL_HOST= export MYSQL_TCP_PORT= export MYSQL_UNIX_PORT= 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 Khomout

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

2011-11-06 Thread Konstantin Khomoutov
On Sun, 6 Nov 2011 15:50:13 -0500 Win Htin 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/

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

2011-11-06 Thread Ben Walton
Excerpts from Win Htin's message of Sun Nov 06 15:50:13 -0500 2011: > 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? Make yourself a quick tunnel with ssh or use nc (n

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

2011-11-06 Thread Win Htin
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? TIA, Win On Sun, Nov 6, 2011 at 1:55 PM, Win Htin wrote: > Hi folks, > > If the bacula database is completely blown away bu