#!/bin/sh

DBHOST="localhost"
DBNAME="tikiwiki"
USERTABLE="users_users"
USERGROUPTABLE="users_usergroups"
DBUSER="***"
DBPASS="***"
MYSQLDUMP="/usr/bin/mysqldump"
MDOPTIONS="-h$DBHOST -u$DBUSER -p$DBPASS"
USERSOPTIONS="--add-drop-table"
GROUPOPTIONS="-t -w groupName='Registered'"
GROUPOPTIONSDEV="-t -w groupName='Developers'"
WORKDIR="/home/mose/var/tikidumps"
OLDIR=`pwd`

cd $WORKDIR
rm -f tikidump.sql.* 2&> /dev/null

$MYSQLDUMP $MDOPTIONS $USERSOPTIONS $DBNAME $USERTABLE > tikidump.sql
$MYSQLDUMP $MDOPTIONS $GROUPOPTIONS $DBNAME $USERGROUPTABLE >> tikidump.sql
$MYSQLDUMP $MDOPTIONS $GROUPOPTIONSDEV $DBNAME $USERGROUPTABLE >> tikidump.sql

bzip2 tikidump.sql
scp -qp tikidump.sql.bz2 doc.tiki.org:~/

cd $OLDIR