-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Seems to me the MySQL backup script on the wiki may do this, but I could be thinking of the svn backup script. Perhaps that one would help, though, as I know it does go through one by one.
Seems to me this would be a pretty easy job though -- you first select to see which databases are on the machine and use this list to loop through and back each one up. No problem, right? I'm not sure, myself. =R Ludovic Strappazon wrote: > 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 - -- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGVFUlmb+gadEcsb4RAsrMAJ9ygTPP7DK4GVf/Tu9p+k/lrDj0dQCfd3Fm 9Z53HvjoyspxQnacDSJkOHc= =RhKL -----END PGP SIGNATURE----- ------------------------------------------------------------------------- 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