Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Chris Hoogendyk
Jordi Espasa Clofent wrote: >> Exactly. Live databases always have to be treated specially. You can use >> a separate tool to back them up to disk space which is then backed up to >> tape by the network backup. >> > > Ok Chris. Is the correct way, I suppose. > What a pitty that Bacula can'

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Chris Hoogendyk
Dan Langille wrote: > On 13 Sep 2007 at 19:23, Jordi Espasa Clofent wrote: > > >> Hi all, >> >> We (a little webhosting company) are planning to use Bacula in >> production as a backup solution. But, first of all we need to resolve >> one important and essencial question: >> >> ¿Is Bacula a

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread John Drescher
> We are talking about using bacula for both. Just with backing up > databases you run a script that dumps the database first to a file > then bacula performs a backup on that file. See the > make_catalog_backup script. > There is a section in the manual that talks about this: http://bacula.org/de

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread John Drescher
> Ok Dan. So ¿how do you do the ddbb backups if Bacula isn't a reliable > solution in this case? I must assume that the correct way would be to > work in both ways: Bacula for "normal" data and specialized tools (as > mysqldump) for "special" data. > We are talking about using bacula for both. Just

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Jordi Espasa Clofent
> Exactly. Live databases always have to be treated specially. You can use > a separate tool to back them up to disk space which is then backed up to > tape by the network backup. Ok Chris. Is the correct way, I suppose. What a pitty that Bacula can't do it. -- Thanks, Jordi Espasa Clofent --

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Chris Hoogendyk
Jordi Espasa Clofent wrote: >> Recommended solution: always use mysqldump. >> > > Ok Dan. So ¿how do you do the ddbb backups if Bacula isn't a reliable > solution in this case? I must assume that the correct way would be to > work in both ways: Bacula for "normal" data and specialized to

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Jordi Espasa Clofent
> Recommended solution: always use mysqldump. Ok Dan. So ¿how do you do the ddbb backups if Bacula isn't a reliable solution in this case? I must assume that the correct way would be to work in both ways: Bacula for "normal" data and specialized tools (as mysqldump) for "special" data. -- T

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Frank Sweetser
Jordi Espasa Clofent wrote: > Hi all, > > We (a little webhosting company) are planning to use Bacula in > production as a backup solution. But, first of all we need to resolve > one important and essencial question: > > ¿Is Bacula a reliable method to backup an _active_ databases (normally >

Re: [Bacula-users] Bacula and ddbb (MySQL) backups

2007-09-13 Thread Dan Langille
On 13 Sep 2007 at 19:23, Jordi Espasa Clofent wrote: > Hi all, > > We (a little webhosting company) are planning to use Bacula in > production as a backup solution. But, first of all we need to resolve > one important and essencial question: > > ¿Is Bacula a reliable method to backup an _activ