Thanks for all the ideas on this. re: userfiles/db sync, would this work..?
backup: 1. mysqldump to date-stamp-named files 2. rsync -arv /data/base2/files/ /backup/base2/files (note, no --delete option on purpose) restore: 1. undump whichever mysqldump is needed 2. copy over all files that are older than the mysqldump The one problem I see is that the restore can bring back files that had been deleted in BASE. I doubt these would interfere with the running of BASE however. A small program could be written to delete any files that are not known about by the db (unless there is already something to do this). Alternatively, one can add the --delete option to rsync and live with only being able to restore the latest dump (which is OK for us for now). cheers, Bob. Nick Loman writes: > Nicklas Nordborg wrote: > > >> You might consider using mysqlhotcopy to get the files out, either on > >> the master or the replica, as this is much quicker than mysqldump. > > > > No we can't since it doesn't work with InnoDB tables. > > Ah true. I guess a replica is the best way to go in that case. > > I've never tried it but you could have your replica server set up with > MyISAM tables and then use mysqlhotcopy from there. > > Cheers > > Nick. > > ------------------------------------------------------------------------- > 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] -- 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]
