dd

#!/bin/sh

DB_DIR=/usr/local/mysql/data
PIDFILE=${DB_DIR}/`/bin/hostname -s`.pid
PROGNAME=mysqld

# Source function library
. /usr/local/etc/rc.d/functions

case "$1" in
        start)
                cd /usr/local/mysql
                if [ -x /usr/local/mysql/bin/mysqld_safe ]; then
                        /usr/bin/limits -U mysql \
                        /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=${DB_DIR} --pid-file=${PIDFILE} > /dev/null &
                        if [ $? -ne 0 ]
                        then
                                echo -e 'Starting mysqld:\t\t[ FAILED ]'
                        else
                                echo -e 'Starting mysqld:\t\t[ OK ]'
                        fi
                fi
                ;;
        stop)
                if [ -f ${PIDFILE} ]; then
                        /bin/kill `cat ${PIDFILE}` > /dev/null 2>&1 && echo -e "Stopping mysqld:\t\t[ OK ]"
                else
                        echo -e "Stopping mysqld:\t\t[ FAILED ]"
                fi
                ;;
        restart)
                $0 stop
                $0 start
                ;;
        status)

               status $PROGNAME
                ;;
        *)
                echo ""
                echo "Usage: `basename $0` { start | stop | restart }"
                echo ""
                exit 64
                ;;
esac