#!/usr/bin/sh
#
#        William Pool (Puddle) 01/05 & Jonas Dias 06/08
#        SMF Method file for MySQL on OpenSolaris 2008.05
#        E-mail: puddle@flipmotion.com & Jonas.Dias@Sun.com
#
# This uses OpenSolaris Sun's default MySQL packages
# SUNWmysql5 
# 
# Modify accordingly!
#
# NOTE: Make sure DB_DIR is owned BY the mysql user and group and chmod 
# 700.
#

#.. /lib/svc/share/smf_include.sh

DB_DIR=/var/mysql/5.0/data
PIDFILE=${DB_DIR}/`/usr/bin/uname -n`.pid

case "$1" in
        start)
        /usr/mysql/bin/mysqld_safe --user=mysql > /dev/null &
                ;;
        stop)
                if [ -f ${PIDFILE} ]; then
                /usr/bin/pkill mysqld_safe >/dev/null 2>&1
                /usr/bin/kill `cat ${PIDFILE}` > /dev/null 2>&1
                fi
                ;;
	'restart')
        if [ -f ${PIDFILE} ]; then
                /usr/bin/pkill mysqld_safe >/dev/null 2>&1
                /usr/bin/kill `cat ${PIDFILE}` > /dev/null 2>&1
        fi
        while pgrep mysqld > /dev/null
        do
          sleep 1
        done
        /usr/mysql/bin/mysqld_safe --user=mysql > /dev/null &
        ;;
        *)
                echo ""
                echo "Usage: `basename $0` { start | stop | restart }"
                echo ""
                exit 64
                ;;
esac

#---EOF