#!/bin/bash

# $Id: dump_wiki_sh.txt,v 1.3 2006/09/19 15:03:37 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-"