Import /etc/localtime to MySQL and set its TimeZone to SYSTEM

mysql-timezone-setup.sh

#!/bin/bash


user='root'
password='default'
mysql_bin='mysql'


function set_up_bin() {
	if [ "${user}" == "" ]; then
		echo "WARNING: user was not set."
	else
		mysql_bin="${mysql_bin} -u${user}"
	fi

	if [ "${password}" == "" ]; then
		echo "WARNING: password was not set."
	else
		mysql_bin="${mysql_bin} -p${password}"
	fi
	mysql_bin="${mysql_bin} -e"
}

function run_query() {
	query_result=$(${mysql_bin} "${1}")
}



echo 'Setting up MySQL calls...'
set_up_bin


echo 'Importing Sao_Paulo TimeZone from /etc/localtime to MySQL internal database...'
mysql_tzinfo_to_sql /etc/localtime Sao_Paulo | mysql -u${user} mysql -p${password}


echo 'Getting MySQL TimeZone info from @@global.time_zone and @@session.time_zone internal variables...'
run_query 'SELECT @@global.time_zone, @@session.time_zone;'
echo ${query_result} | while read not_used not_used session_tz global_tz; do
	echo -n "@@global.time_zone: "
	if [ "${global_tz}" == 'SYSTEM' ]; then
		echo "SYSTEM (OK)"
	else
		echo "${global_tz} (WARNING)"
		echo 'Setting @@global.time_zone to SYSTEM...'
		run_query 'SET GLOBAL time_zone = SYSTEM;'
	fi

	echo -n "@@session.time_zone: "
	if [ "${session_tz}" == 'SYSTEM' ]; then
		echo "SYSTEM (OK)"
	else
		echo "${session_tz} (WARNING)"
		echo 'Setting @@global.time_zone to SYSTEM...'
		run_query 'SET SESSION time_zone = SYSTEM;'
	fi
done