MySQLdump is a good tool, there are others, but usually the whole
process is scripted to fit the local environment.

Just like many mail servers, databases should be quiescent (the server
stopped) while the dump takes place to ensure consistency. If you want
to really minimize the downtime, then using LVM snapshotting is a good
option.

1. shut down the service
2 take the snapshot
3 re start the service
4 run the dump from the snapshot
5 delete the snapshot
6 let BPC capture the dump

IMO "robustness" comes from regular and thorough monitoring and
testing, ultimately by human sysadmins. Automation tech helps make the
tasks easier, but is not a substitute for human attention and test
recoveries from realistic simulations of possible disasters - even
monitoring and testing systems can break down.



On Sat, Mar 26, 2011 at 12:38 PM, Lord Sporkton <lordsporkton AT gmail DOT com> 
wrote:
> I have seen some examples of using a local backup script to dumpmysql
> to a local dir, then backup that local dir via BPC, but i was hoping
> for something a little more robust. I was looking into replacing the
> tar commands that pipe back to ssh with a mysqldump command so it
> pipes one big sqldump file into BPC, and ive been looking at the local
> script method but neither seems very robust. I was hoping maybe there
> was like a plugin or something that would create an extra backup
> method or something like that. preferrably i was hoping to be able to
> backup individual databases as individual files.
>
> Is there any current methods for this ?
>
> Thank you
> Lawrence
>

------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software 
be a part of the solution? Download the Intel(R) Manageability Checker 
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/