Hello Giuseppe, i would suggest the second approach (mysqldump) because bacula is using the database (the director) and if you stop mysql..... :-))
btw... it's never a good idea to save the database-storage without any procedure to lock databases before (and i don't know if there's such procedure in mysql). christian -- "I sense much NT in you, NT leads to Blue Screen. Blue Screen leads to downtime, downtime leads to suffering. NT is the path to the darkside." - Unknown Unix Jedi > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Giuseppe > Sent: Thursday, March 30, 2006 12:33 PM > To: bacula-users@lists.sourceforge.net > Subject: [Bacula-users] Mysql databases backup > > Hi! > This is not really a problem, I'm just asking which is the > best way to > do a thing. > I've to backup about 13GB of Mysql Databases, so I 've 2 possibile > solutions: > > 1) include /var/lib/mysql in fileset resource > 2) run "mysqldump --all-databases" before job > > Should I stop mysqld before a backup? > > Which is the best way to do so? > Any other suggestion is well accepted! :) > > Thanks! > > Giuseppe > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking > scripting language > that extends applications into web and mobile media. Attend > the live webcast > and join the prime developer group breaking into this new > coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720& > dat=121642 > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users