More on this backup thread...
It's nice to empty files from the trash can before doing a backup, since this
helps reduce the number of files building up in the rsync'ed backup (if you do
it the way I have described).
I couldn't find an easy way to get a list of removed files in the web GUI
Bob MacCallum wrote:
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
Nicklas Nordborg writes:
Bob MacCallum wrote:
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).
No there is no
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
We are also currently setting up a backup system for the main server
here in Lund. I am not really taking part of the practical work. My
responsibility is more to think out scenarios that would break the
backup system.
I think it would be good to discuss this on the mailing list and I hope
Jari Häkkinen wrote:
Why use svn? Do you need to track changes to files?
Tracking changes will in any case not be possible. Changing an uploaded
file in BASE results in a new file with a new name. It will most likely
also be located in a different directory since the subdirectories in the
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
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