#!/bin/sh
#
# -- san2(at)wdb.co.kr
# -- 2004.12.31 : add `wait_shutdown'
# -- 2004.11.15 : new build

## check real-running
##
is_running()
{
  [ -n "`/bin/ps ac | grep mysqld 2>/dev/null`" ] && echo 1
}

## same as `mysqladmin shutdown'
##
wait_shutdown()
{
  #sleep 1; while [ -n "`is_running`" ] ; do :; done
  sleep 1; while [ -f ${PIDFILE} ] ; do :; done
}

DB_DIR=/databases/mysql
LOG_DIR=/databases/mysqldlog
PIDFILE=${LOG_DIR}/mysqld.pid

case "$1" in
	start)
		if [ -s ${PIDFILE} -o -n "`is_running`" ] ; then
			echo 'mysqld running !!!' >&2
			exit 1
		elif [ -x /usr/local/bin/mysqld_safe ] ; then
			/usr/bin/limits -U mysql \
			/usr/local/bin/mysqld_safe --user=mysql --datadir=${DB_DIR} --pid-file=${PIDFILE} >/dev/null &
			[ $? = 0 ] && echo -n ' mysqld'
		fi
		;;
	stop)
		if [ -s ${PIDFILE} ] ; then
			/bin/kill `cat ${PIDFILE} 2>/dev/null` >/dev/null 2>&1 && wait_shutdown && echo -n ' mysqld'
		elif [ -n "`is_running`" ] ; then
			/usr/bin/killall mysqld && wait_shutdown && echo -n ' mysqld'
		else
			echo "mysql-server isn't running" >&2
			exit 1
		fi
		;;
	*)
		echo ""
		echo "Usage: `basename $0` { start | stop }"
		echo ""
		exit 64
		;;
esac

exit 0