Download → files/dump wiki sh.txt
#!/bin/bash
# $Id: dump-wiki.html,v 1.45 2007/06/15 11:49:14 webcms Exp $
# Location: tertius
#
# MediaWiki 1.7.1
#
# Usage:
# ./dump_wiki.sh <db prefix>, e.g.
# ./dump_wiki.sh "reto_"
#
# Documentation:
# http://www.infocopter.com/know-how/mediawiki-reference/dump-wiki.html
TPREF=$1
BAKPREF="wikidb_"
for TABNAME in archive categorylinks externallinks filearchive hitcounter image imagelinks interwiki ipblocks job langlinks logging math objectcache oldimage page pagelinks querycache querycache_info recentchanges revision searchindex site_stats templatelinks text trackbacks transcache user user_groups user_newtalk validate
do
COMPLETE_LIST="$COMPLETE_LIST $TPREF$TABNAME"
done
WIKINAME=`echo $TPREF | sed 's/_$//'`
echo "Dump Wiki $WIKINAME ..."
# YYYYMMDD:
mydate=`date +%Y%m%d`
mysqldump -u root wikidb $COMPLETE_LIST > $BAKPREF$WIKINAME-$mydate.dump
tar -czf $BAKPREF$WIKINAME-$mydate.tar.gz $BAKPREF$WIKINAME-$mydate.dump
rm -f $BAKPREF$WIKINAME-$mydate.dump
ls -l "$BAKPREF$WIKINAME-$mydate.tar.gz"
echo "done"
# -- cleanup (http://www.infocopter.com/perl/cleanup.html)
/usr/local/bin/cleanup.pl 10 "$BAKPREF$WIKINAME-"
See also:
Home > Know-how >
MediaWiki - CMS >
Administration of MediaWiki > Dump MediaWiki - Reference