Can I just grab the tarballs? Would that cover the bulk of what needs
backing up?
There's no special need, I think, to backup the software (which is on
sourceforge). Probably a backup of the apache conf files, /etc/, the
mailing lists... what else?
Brion Vibber wrote:
On Wed, 2003-09-10 at 05:29, Jimmy Wales wrote:
Tim Starling wrote:
Does anyone back up the image and oldimage
tables, the user table, the
watchlist table and the sitestats table? How often are the images
themselves backed up?
Good question. I backup everything using rsync to my home computer.
Just a note: rsync would work great for images uploads and general
stuff, but it won't work for the live database files. These files are
being changed constantly, so any attempt to copy them while MySQL is
running and making updates to them is likely to net you only a corrupted
copy. The tables could perhaps be locked during the rsync, but I don't
know how long it would take to rsync the ~15 gigabyte innodb table
space.
One thing to think about is the binary update log (currently not enabled
on pliny). MySQL can keep a log of all updates to the tables it manages,
for the purpose of sending the updates on to slave servers to keep
replicated copies of the databases up to date.
It may be possible to extract just the updates to the cur and old tables
and produce runnable SQL which can be made available for download for
nightly incremental backup updates.
(Also, a complete replicated server could be set up.)
-- brion vibber (brion @
pobox.com)
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)Wikipedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l