Hi, We are working on a backup scheme here in Lund. We'll send a note when we have something that at least works. Then we can all improve our backup strategy ;-)
Why use svn? Do you need to track changes to files? For the userfiles directory a simple rsync should be fine, it is incremental (transfers only changes). Cheers, Jari Bob MacCallum skrev: > Hi all, > > Does anyone have any genius solutions for backing up BASE2? We're trying to > get a major production server online and obviously backups would be quite > useful. > > I can do what we already do for BASE1: periodic full mysqldump and rsync of > BASE's filestore to an off-site location. That approach only allows me to > restore to the latest full dump (to keep db and files in sync). > > I wonder if subversion could be used to manage the "userfiles" directory > in BASE2? (i.e. commit new files to svn at the same time as a mysqldump was > done). I suspect this is a heavier workload than svn was designed for. > > A more incremental approach to backing up the db would be useful when we are > in the tens/hundreds of gigs. Maybe a slave mysql server? Could that work > reliably between two distant sites? > > Any ideas? > > cheers, > Bob. > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
