Marc a écrit :
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.
I can't imagine a way to back them up one by one in a single job.
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.
I think I don't understand that.
Regards,
Ludovic Strappazon.
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
