Re: [Bacula-users] right solution for backup MySQL databases

2005-09-02 Thread Phil Stracchino
Dmitry S. Vlasov wrote: > Hello! > Can anyone tell me right solution for backup MySQL databases (MyISAM and > InnoDB) without slave server ( i mean without any replication) and > without stopping service? > How I feel, backup binary files on-the-fly is realy bad idea :) Look up the manual pages fo

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Ted S
On Friday 02 September 2005 06:36 am, Dan Langille wrote: > On 2 Sep 2005 at 15:22, Heigl Florian - Munich-MR - e wrote: > > > >How much time? I ask because it sounds like you are assuming and > > > >have not actually tried it. > > > > [ I think in general it's not bad to think about things impact

Re: [Bacula-users] schedule resource

2005-09-02 Thread Phil Stracchino
Maurizio Santini wrote: > Hi, > > Just a question about the schedule resource. If the Pool directive is > not defined like in > > # This schedule does the catalog. It starts after the WeeklyCycle > Schedule { > Name = "WeeklyCycleAfterBackup" > Run = Full sun-sat at 1:10 > } > > ...does

Re: [Bacula-users] schedule resource

2005-09-02 Thread Matthias Kurz
On Fri, Sep 02, 2005, Maurizio Santini wrote: > Hi, > > Just a question about the schedule resource. If the Pool directive is > not defined like in > > # This schedule does the catalog. It starts after the WeeklyCycle > Schedule { > Name = "WeeklyCycleAfterBackup" > Run = Full sun-sat a

Re: [Bacula-users] Bacula performance

2005-09-02 Thread Uwe Hees
Hello all, I finally found a solution to speed up the performance dramatically: In the FileDaemon resource I set "Maximum Network Buffer Size = 65536" (instead of the default 32k). Now I get ~3MB/sec, which is reasonable. Thanks for all assistance, Uwe Am 31.08.2005 um 18:28 schrieb Uwe Hee

[Bacula-users] Core dump with 1.36.3 on FreeBSD 5.4, "Fatal Error because: Bacula interrupted by signal 10: BUS error"

2005-09-02 Thread Josh Endries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I noticed someone else had the same error a couple months ago. My test server's director died this morning mid-backup with the "BUS error" in the subject: "Fatal Error because: Bacula interrupted by signal 10: BUS error" It's running on a Pen

RE: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Heigl Florian - Munich-MR - external
> >How much time? I ask because it sounds like you are assuming and > >have not actually tried it. [ I think in general it's not bad to think about things impact before trying :) ] > >My usual stance is: What is more important to you? a fast backup or > >a reliable backup? > > > > > > > yo

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: > if i want to backup a server running a mysql-db and i just backup > all the mysql-db-files, do i risk to save a corrupted version? i read > in the manual about the VSS problematic and save state in RDBMS > on windows, but in my case, the mysql

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Jeronimo Zucco
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You only can copy the database files for mysql if table type is MyISAM. If you use innodb, only dump or using software InnoDB Hot Backup (it is not GPL). You can dump with lock database (is available only for queries in this time) for p

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
Dan Langille wrote: On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in

[Bacula-users] schedule resource

2005-09-02 Thread Maurizio Santini
Hi, Just a question about the schedule resource. If the Pool directive is not defined like in # This schedule does the catalog. It starts after the WeeklyCycle Schedule { Name = "WeeklyCycleAfterBackup" Run = Full sun-sat at 1:10 } ...does it mean that it uses the "Default" pool? Thank

RE: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
On 2 Sep 2005 at 15:22, Heigl Florian - Munich-MR - e wrote: > > > >How much time? I ask because it sounds like you are assuming and > > >have not actually tried it. > > [ I think in general it's not bad to think about things impact before > trying :) ] Worthwhile. But one must also act with

Re: [Bacula-users] Compiling problems on AIX 5.2

2005-09-02 Thread Martin Simmons
> On Fri, 2 Sep 2005 08:33:33 +0200 (CEST), "Daniel Kropveld" <[EMAIL > PROTECTED]> said: Daniel> I have tried to compile bacula 1.36.3 (22 April 2005) on AIX 5.3.0.0 Daniel> with mysql (server, client, devel) installed from the AIX rpm's. Daniel> Using the following command: Da

[Bacula-users] Alternative PDF version of Bacula manual with section numbering

2005-09-02 Thread Andrew Ford
I have volunteered to edit the Bacula documentation. One of the first things I am doing is adding chapter and section numbering to the PDF versions of the manuals. These changes will not be committed to CVS before the second half of September and will probably not make it to the documentation

Re: [Bacula-users] Bacula performance solved!

2005-09-02 Thread Uwe Hees
Hello all, I finally found a solution to speed up the performance dramatically: In the FileDaemon resource I set "Maximum Network Buffer Size = 65536" (instead of the default 32k). Now I get ~3MB/sec, which is reasonable. Thanks for all assistance,# Uwe Am 31.08.2005 um 18:28 schrieb Uwe He

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Davide Bolcioni
Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. I believe

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Umberto Nicoletti
On 9/2/05, Philipp Steinkrueger <[EMAIL PROTECTED]> wrote: > Hi, > > > if i want to backup a server running a mysql-db and i just backup > all the mysql-db-files, do i risk to save a corrupted version? i read > in the manual about the VSS problematic and save state in RDBMS > on windows, but in m

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
On 2 Sep 2005 at 14:16, Philipp Steinkrueger wrote: > Dan Langille wrote: > > >On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: > > > > > > > >>if i want to backup a server running a mysql-db and i just backup > >>all the mysql-db-files, do i risk to save a corrupted version? i read > >>in t

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
Dan Langille wrote: On 2 Sep 2005 at 14:16, Philipp Steinkrueger wrote: Dan Langille wrote: On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version?

[Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
Hi, if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs b

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
Hi, Jonas Björklund wrote: Hello, On Fri, 2 Sep 2005, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows

Re: [Bacula-users] right solution for backup MySQL databases

2005-09-02 Thread Dmitry S. Vlasov
Arno Lehmann wrote: Hello, Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :)

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Jonas Björklund
Hello, On Fri, 2 Sep 2005, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db

Re: [Bacula-users] right solution for backup MySQL databases

2005-09-02 Thread Arno Lehmann
Hello, Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) There are different opt

Re: [Bacula-users] right solution for backup MySQL databases

2005-09-02 Thread Rowdy
Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) mysqldump? Indeed, Bacula will us

[Bacula-users] right solution for backup MySQL databases

2005-09-02 Thread Dmitry S. Vlasov
Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) ---

[Bacula-users] Compiling problems on AIX 5.2

2005-09-02 Thread Daniel Kropveld
I have tried to compile bacula 1.36.3 (22 April 2005) on AIX 5.3.0.0 with mysql (server, client, devel) installed from the AIX rpm's. Using the following command: ./configure \ > --enable-smartalloc \ > --sbindir=/opt/bacula/bin \ > --sysconfdir=/opt/bacula/bin \ > --with-pid-dir=/opt/bacula