#!/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:.

. /etc/netflow/install.conf

if [ ! -d "$NETFLOWDIR/config" ]; then
    echo "Can't open backup config directory $NETFLOWDIR/config!"
    exit 1
fi


mydb_ok=0
while (( !$mydb_ok ))
do
    read -p "Type root username for access to mysql database [root]:" username
    read -p "Type root password for access to mysql database []:" password
    MYSQLOPTION="$MYSQLOPT"
    if [ -z "$username" ]; then
	MYSQLOPTION="$MYSQLOPTION -u root"
    fi
    if [ -n "$password" ]; then
	MYSQLOPTION="$MYSQLOPTION --password=$password"
    fi
    MYSQL="$MYSQL_BIN $MYSQLOPTION"
    MYSQLDUMP="$MYSQLDUMP_BIN $MYSQLOPTION"
    echo "show tables;" | $MYSQL -s $DATABASE &> /dev/null
    mydb_ok=$(( ! $? ))
done



echo -n "Restoring old configuration from $NETFLOWDIR/config "
for TABLE in `ls "$NETFLOWDIR/config"`
do
  cat "$NETFLOWDIR/config/$TABLE" | $MYSQL -s $DATABASE
  echo -n "."
done
echo "DONE."
