[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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] Mysql databases backup
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=lnkkid=110944bid=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=lnkkid0944bid$1720dat1642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Mysql databases backup
Giuseppe wrote: 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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi Giuseppe, Might I suggest a look at mysqlhotcopy. This would be quite a bit faster than mysqldump and may do what you need it to do given the size of your DB's. You can find out about it here http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html I'm not sure of the version that you are using but this hasn't changed much since it first came in. There is also a java version shown on the web page. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout --- 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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users