#!/bin/bash

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

. /etc/netflow/install.conf

rm -rf "$NETFLOWDIR/config" &> /dev/null
mkdir "$NETFLOWDIR/config" &> /dev/null

if [ ! -d "$NETFLOWDIR/config" ]; then
    echo "Can't create 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 "Backuping old configuration to $NETFLOWDIR/config "
for TABLE in `echo "SHOW TABLES like 'x%'" | $MYSQL -s $DATABASE`
do
    echo "DELETE FROM $TABLE;" > "$NETFLOWDIR/config/$TABLE.sql"
    $MYSQLDUMP -c -t -e --add-locks $DATABASE $TABLE | grep -v "^-" >> "$NETFLOWDIR/config/$TABLE.sql"
    echo -n "."
done
echo "DONE"
