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

[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 win.h...@gmail.com wrote: Hi folks, If the bacula database is completely

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

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 win.h...@gmail.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

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

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

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 please

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