[Mediawiki-l] Backup system

[Sheldon Rampton]

Can anyone here give me some suggestions for the best way to back up  
the database for our website? Originally we used a cron job that did a  
MySQL dump every evening, but as the size of our wiki has grown, the  
time needed just to run the dump has grown. It now takes 30-45  
minutes, during which time site performance bogs down. We've therefore  
tried doing live MySQL replication instead to maintain a mirror of the  
database, but that doesn't seem to work very well.

Is there some other approach that we should be trying?

-------------------------------------------

SHELDON RAMPTON
Research director, Center for Media & Democracy
Center for Media & Democracy
520 University Avenue, Suite 227
Madison, WI 53703
phone: 608-260-9713

Subscribe to our free Weekly Spin email:
<http://www.prwatch.org/cmd/subscribe_sotd.html>

Subscribe to our Weekly Radio Spin podcasts:
<http://www.prwatch.org/audio/feed>

Read and add to articles on people, issues and groups shaping the
public agenda:
<http://www.sourcewatch.org>

Support independent, public interest reporting:
<http://www.prwatch.org/donate>