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 <[email protected]> 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 [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
