#!/bin/bash

# Declare Variables
mysql="192.168.1.100"
mariadb="127.0.0.1"
mysql_user="root"
mysql_pass="My$ql"
mariadb_user="root"
mariadb_pass="M@r1a"

# Migrate Function
function migrate
{
	echo #####################
	echo Dumping Database - $1
	mysqldump --routines -h $mysql -u $mysql_user -p$mysql_pass $1 > $1.dump
	echo Converting Tables - $1
	cat $1.dump | sed -e 's/MyISAM/InnoDB/g' > $1.sql
	echo Creating Database - $1
	mysql -h $mariadb -u $mariadb_user -p$mariadb_pass mysql -e "CREATE DATABASE $1"
	echo Migrating Database - $1
	mysql -h $mariadb -u $mariadb_user -p$mariadb_pass $1 < $1.sql
	echo Migration Complete - $1
} 

# Migrate Databases
migrate "openfire"
migrate "postfix"
migrate "projects"
migrate "pureftp"
migrate "security"
migrate "statistics"
migrate "webmail"

# Database Optimization
echo ####################
echo Optimizing Databases
mysqlcheck -o -s --all-databases -h $mariadb -u $mariadb_user -p$mariadb_pass > optimize.txt
echo Optimization Complete
echo ####################