#!/bin/sh
#
# Restore MySQL database contents from a file.
#
# Last modified: Jul 25, 2004
#
# Copyright (c) 2004 Mariusz Zynel.
#
# This  software  is  FREE.  You can use  and/or  redistribute  it for any
# purpose in either,  modified, or unmodified form, under the terms of the
# GNU General Public License as published by the Free Software Foundation.
#
# The above copyright notice and this permission  notice shall be included
# in all copies or substantial portions of this software.
#
# THIS  SOFTWARE IS PROVIDED AS IS AND COME WITH NO WARRANTY  OF ANY KIND,
# EITHER  EXPRESSED OR IMPLIED.  IN NO EVENT WILL THE COPYRIGHT  HOLDER BE
# LIABLE FOR ANY DAMAGES RESULTING FROM THE USE OF THIS SOFTWARE.

SELF=`basename $0`

PATH=/usr/bin:/opt/cfw/bin

USER=root

if [ $# -eq 2 ]; then
    DATABASE=$1
    FILENAME=$2
else
    if [ $# -eq 4 -a "$1" = "-u" ]; then
        USER=$2
        DATABASE=$3
        FILENAME=$4
    else
        echo "Usage: $SELF [-u user] database filename"
        exit 1;
    fi
fi

echo "Drop database $DATABASE before restoration (y/n)?"
read KEY

stty -echo
echo "Enter MySQL user $USER password:"
read PASSWD
stty echo

if [ "$KEY" = "y" ]; then
    mysql -u $USER -p$PASSWD -e "drop database $DATABASE; create database $DATABASE"
fi

if mysql -u $USER -p$PASSWD $DATABASE < $FILENAME
then
    echo "Database restored from file: $FILENAME"
fi