#!/bin/sh

CHRDIR=/chroot/admin

exec_sql()
{
if [ $# -ne 2 ]
    then
    echo "Programing error!"
    exit 200
fi
mysql --defaults-file=$CHRDIR/etc/mysql/debian.cnf --socket=$CHRDIR/run/mysqld/mysqld.sock -ss -n $1 <<STOP
$2
\q
STOP
if [ $? -ne 0 ] ; then  echo "SQL job FAILed ! user:$user " >&2
exit 131
fi
}

usage()
{
    echo "Usage: $0 [db] [dumpfile]"
}

if [ $# -ne 2 ]
then
usage
exit 7
fi

db=$1
FILE=$2

if [ -f $FILE ]; then
    echo "Importalas: $db adatbazisba, file: $FILE"
    exec_sql $db "set autocommit=0; set unique_checks=0; set foreign_key_checks=0;
		source $FILE
		commit; set unique_checks=1; set foreign_key_checks=1;"
else
    echo "File not found: $2"
fi