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