#!/bin/bash

# MySQL  restore script
# by Adeel Ahmad {adeel.ahmad+hackinggurus@networkncc.com}
# for http://www.hacking-gurus.net

# Please start configuring here
MUSER="root"
MPASS=""
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
#backup directory
BACKUPDIR="/backup/mysql/"

### Dont Edit Below ###

DBS="$($MYSQL -h $MHOST -u $MUSER -p$MPASS  -Bse 'show databases')"

function search_array() {
    index=0
    while [ "$index" -lt "${#DBS[@]}" ]; do
        if [ "${DBS[$index]}" = "$1" ]; then
            echo $index
            return
        fi
        let "index++"
    done
    echo ""
}


mkdir -p $BACKUPDIR

lcdbs=$(find $BACKUPDIR -name '*.sql' )



for db in $lcdbs
do

		echo $db
 
		dbame=${db%.sql}
		index=$(search_array $dbame)
		
		if [ -z "$index" ]; then
		
			cmd = 'create database '.$dbname
		else
			
			cmd = 'TRUNCATE '.$dbname
		fi
		
		echo $cmd
		$MYSQL -h $MHOST -u $MUSER -p$MPASS  -Bse '\$cmd'\
		
		$MYSQLDUMP -h $MHOST -u $MUSER -p$MPASS  $dbname  < $BACKUPDIR$db

done