#!/bin/bash

clear

echo "########################################################"
echo "##        the IP Company database recovery tool       ##"
echo "##                    Version 1.0                     ##"
echo "##                                                    ##"
echo "##                Please use with care                ##"
echo "##                                                    ##"
echo "##               For bugs & questions:                ##"
echo "##            pdenhartog@theipcompany.nl              ##"
echo "##                                                    ##"
echo "########################################################"

echo "Select a database to restore from the list:"

PS3="Database:"

list=(`ls /root/database-backup/database`)
select opt in "${list[@]}"
do
echo "Importing $opt"

logger "database restore started."

MYSQLUSER=root
MYSQLPASSWORD=Welkom#1

PAD=/root/database-backup/database/$opt/

cd $PAD

# architecture
for I in `ls -d */ `; do
QUERY=`ls $I | grep architecture`
	echo "Import architecture file: $PAD$I$QUERY"
	cat $PAD$I$QUERY | mysql -u $MYSQLUSER --password=$MYSQLPASSWORD
done

#view
for I in `ls -d */ `; do
QUERY=`ls $I | grep view`
	echo "Import view file: $PAD$I$QUERY"
	cat $PAD$I$QUERY | mysql -u $MYSQLUSER --password=$MYSQLPASSWORD
done

#data
for I in `ls -d */ `; do
QUERY=`ls $I | grep data`
	echo "Import data file: $PAD$I$QUERY"
	cat $PAD$I$QUERY | mysql -u $MYSQLUSER --password=$MYSQLPASSWORD
done

#triggers
for I in `ls -d */ `; do
QUERY=`ls $I | grep triggers`
	echo "Import triggers file: $PAD$I$QUERY"
	cat $PAD$I$QUERY | mysql -u $MYSQLUSER --password=$MYSQLPASSWORD
done

logger "database restore completed."
echo "Done!"
exit
done