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't do it. >
I'm not sure it's a pity. ;-) It's the way tools are. You wouldn't ask Bacula to do your disk mirroring just because that is a form of backup. You use RAID software or hardware to do your disk mirroring. In the same way, databases are specialized and unique. Each database engine has its own mechanisms for table locking, transaction control, database dumping, etc. Those tools are developed within the context of that project. If Bacula developers were going to write that code instead and build it into Bacula, then they would be faced with people who wanted support for PostgreSQL, Oracle, msql, DB2, Sybase.... It's just not a practical way to build tools. John Drescher wrote: >> 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 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. > You can obviously coordinate the tools. What John is talking about is a script controlled by Bacula that initiates the other tool, waits for it to complete, and then backs that up to tape. You could even contrive to run it through a named pipe or socket straight to the network backup program, though I've never tried to get that fancy. --------------- Chris Hoogendyk - O__ ---- Systems Administrator c/ /'_ --- Biology & Geology Departments (*) \(*) -- 140 Morrill Science Center ~~~~~~~~~~ - University of Massachusetts, Amherst <[EMAIL PROTECTED]> --------------- Erdös 4 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
