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. -- Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups | Division of Cell and Molecular Biology | Imperial College London | Phone +442075941945 | Email [EMAIL PROTECTED] ------------------------------------------------------------------------- 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]