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

Reply via email to