#!/bin/sh
host_1="10.30.0.1"
host_2="10.30.0.2"

SUPERUSER='root'
echo -n 'Username:('${SUPERUSER}'):'; read inp
if [ "$inp" != "" ];then SUPERUSER=$inp ; fi;unset inp;
echo -n 'Password:' ;stty -echo ;read inp;stty echo
if [ "$inp" != "" ];then SUPERPASS=$inp; fi

SAVEIFS=$IFS
IFS='
'
if [ "${SUPERUSER}" = "" ]; then
echo "Please specify the username of mysql."
echo "Usage: exportsqlusers root pass"
exit 1
fi
if [ "${SUPERPASS}" = "" ]; then
echo "Please specify the password of mysql."
echo "Usage: exmportsqlusers root pass"
exit 1
fi

rm -f script.sql
rm -f script_final.sql

for HoSt in  $host_1 $host_2 ;do
SCHEMA=`mysql -u ${SUPERUSER} -B -N -p"${SUPERPASS}" -h "$HoSt" -e "SELECT distinct SCHEMA_NAME FROM SCHEMATA where SCHEMA_NAME not in (\"information_schema\",\"mysql\",\"performance_schema\")" information_schema`
for SCHEMA_DB in ${SCHEMA}; do
echo "create database if not exists \'${SCHEMA_DB}\'"\;>>script_final.sql
done


USERS_HOSTS=`mysql -u ${SUPERUSER} -B -N -p"${SUPERPASS}" -h "$HoSt" -e "SELECT user, host FROM user where user not in (\"root\",\"debian-sys-main\")" mysql`
for USER_HOST in ${USERS_HOSTS}; do
NULL_STRING=0   #индикатор пустой строки
#echo ${USER_HOST}
USER=`echo ${USER_HOST} | awk '{print $1}'`
#echo user: ${USER}
HOST=`echo ${USER_HOST} | awk '{print $2}'`
#echo host: ${HOST}
if [ "${USER}" = "" ]; then
NULL_STRING=1
fi
if [ "${HOST}" = "" ]; then
NULL_STRING=1
fi
if [ "${NULL_STRING}" = "0" ]; then
SQL_QUERIES=`mysql -u "${SUPERUSER}" -p"${SUPERPASS}" -B -N  -h "$HoSt" -e"SHOW GRANTS FOR '${USER}'@'${HOST}'"`
for SQL_QUERY in ${SQL_QUERIES}; do
echo ${SQL_QUERY}\; >> script.sql
#echo -----------------------------------------
done
fi
done

done #------for all hosts
IFS=$SAVEIFS
cat script.sql| grep -v 'REPLICATION'| sort | uniq >> script_final.sql
echo "flush privileges"\; >> script_final.sql