#! /bin/sh

##
## restore a whois_rip database from a backup
##

# Copyright (c) 2002                                        RIPE NCC
#
# All Rights Reserved
#
# Permission to use, copy, modify, and distribute this software and its
# documentation for any purpose and without fee is hereby granted,
# provided that the above copyright notice appear in all copies and that
# both that copyright notice and this permission notice appear in
# supporting documentation, and that the name of the author not be
# used in advertising or publicity pertaining to distribution of the
# software without specific, written prior permission.
#
# THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE, INCLUDING
# ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS; IN NO EVENT SHALL
# AUTHOR BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY
# DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN
# AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.


GZIP=/usr/local/bin/gzip

DATABASE=RIPE
TARFILE=${DATABASE}.tar.gz
DATADIR=/var/mysql/data
TMPDIR=/export/dbase/tmp

MYSQLUSER=user
MYSQLPASS=password
MYSQL="/usr/local/mysql/bin/mysql -u$MYSQLUSER -p$MYSQLPASS"
MYSQLADMIN="/usr/local/mysql/bin/mysqladmin -u$MYSQLUSER -p$MYSQLPASS"
MYSQLIMPORT="/usr/local/mysql/bin/mysqlimport -u$MYSQLUSER -p$MYSQLPASS"

# Extract our textual dump
$GZIP -dc $TARFILE | (cd $TMPDIR && tar xf -)

#
cd $TMPDIR
$MYSQLADMIN create ${DATABASE}_snapshot
cat *.sql | $MYSQL ${DATABASE}_snapshot
$MYSQLIMPORT ${DATABASE}_snapshot *.txt