>>>>> On Wed, 23 May 2007 12:28:20 +0200, Marc said: > > I have to maintain a server park with 500+ databases, and databases being > remove and added every day. So defining a job for each database is not an > option.
You can probably build a solution based on fifos, but it will still be complicated if you want to restore only 1 of the 500 databases. See: <http://www.bacula.org/rel-manual/FileSet_Resource.html#readfifo> <http://paramount.ind.wpi.edu/wiki/doku.php?id=application_specific_backups#postgresql> __Martin > Creating a backup of the database files is not what I'm looking for, as I > will be unable to restore Inno databases. Inno databases are stored in one > file, not separate files / directories as MyISAM. > > Regards, > Marc > > -----Oorspronkelijk bericht----- > Van: Jerome Massano [mailto:[EMAIL PROTECTED] > Verzonden: woensdag 23 mei 2007 11:20 > Aan: Marc > CC: bacula-users@lists.sourceforge.net > Onderwerp: Re: [Bacula-users] FW: Backup of a mysql dump of the database > > Hi > > You can do a database by database dump with mysqldump (see man mysqldump). I > suppose you could do what you want by setting multiple > jobs: > > First job has : > Client Run Before Job = mysqldump database1 > file-1 Fileset = file-1-fs > Client Run After Job = rm file-1 > > Second job has : > Client Run Before Job = mysqldump database2 > file-2 Fileset = file-2-fs > Client Run After Job = rm file-2 > > etc... Of course you will have to configure file-1-fs and file-2-fs to > backup file-1 and file-2. > > I think the syntax is false because I did it without looking at the > documentation, but the idea is here. > > If you are using another database, i think there would be an equivalent to > mysqldump. > > Hope that will help > > PS : sorry for my really bad english ^^ > > > Le mercredi 23 mai 2007 à 10:53 +0200, Marc a écrit : > > Hi, > > > > I've searched the archives, but I can not find any relevant information. > > Therefor my question: is it possible to do a database by database dump > > and backup these dump files? Because of database sizes, it would be > > very nice if this can be done database by database. I mean first do > > the dump of database 1, move it to bacula, remove the dump, dump of > > database 2, move it to bacula, etc... > > > > Can this be done? > > > > Kind regards, > > Marc > > > > > > > > ---------------------------------------------------------------------- > > --- This SF.net email is sponsored by DB2 Express Download DB2 Express > > C - the FREE version of DB2 express and take control of your XML. No > > limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users