#!/bin/bash

# Loads the  gzipped mysqldumps in a dir into mysql

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

hn=$1

date

#echo "Fetching old debian.cnf..."
#[ -d /etc/mysql/.old ] || mkdir /etc/mysql/.old
#rsync --inplace -av --delete ${SRC_IP}:/etc/mysql/debian.cnf /etc/mysql/.old/debian.cnf

SQL="SELECT schema_name FROM information_schema.schemata WHERE"
SQL="${SQL} schema_name NOT IN ('information_schema','performance_schema');"

DBS="$(echo $SQL | ssh $hn 'mysql -Bs' )"

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

	for db in $DBS
	do
		if [ "$db" == "information_schema" -o "$db" == "performance_schema" -o "$db" == "mysql" ]; then
			echo "skipping: $db [please migrate manually]"
		else
			date
			echo "importing: $db"
			#echo "create database \`$db\`" | mysql
			(echo "set autocommit=0; set unique_checks=0; set foreign_key_checks=0; set sql_log_bin=0; set global slow_query_log=0; use \`$db\`"; \
			ssh $hn 'mysqldump '$db' -Q -R --triggers --add-drop-table --add-locks --force --quick --disable-keys --lock-tables'; \
			echo "commit; set autocommit=1; set unique_checks=1; set foreign_key_checks=1; set sql_log_bin=1; set global slow_query_log=1;") |mysql
		fi
	done
	date
else
	echo "*** Dry-run ***"
	echo "Databases to migrate:"
	echo "$DBS"
	echo "*** Dry-run ***"
	echo "To really run, supply 'SURE' as second parameter."
fi