#!/bin/bash

# Loads the  gzipped mysqldumps in a dir into mysql

if [ $# -lt 1 ]; then
	echo "usage: $0 [dirname] [SURE]"
	exit 4
fi

date
DUMPS=`find $1/ -mindepth 1 -maxdepth 1 -name '*.sql.gz'`

if [ $# -gt 1 -a "x$2" == "xSURE" ]; then

	for i in $DUMPS
	do
		if [ "$i" == "information_schema" -o "$i" == "performance_schema" -o "$i" == "mysql" ]; then
			echo "skipping: $i [please import manually]"
		else
			#db=`echo "$i" | cut -d'.' -f1 | cut -d'/' -f2`
			db=`basename "$i" | sed -e 's/.sql.gz$//'`
			echo "importing: $db"
			echo "create database \`$db\`" | mysql
			zcat $i | mysql $db
		fi
	done
	date
else
	echo "*** Dry-run ***"
	echo "Databases to import:"
	echo "$DUMPS"
	echo "*** Dry-run ***"
	echo "To really run, supply 'SURE' as second parameter."
fi