#!/bin/bash
#
# Load OS variables
source /etc/bashrc
source /etc/prefile

# Define variables
RETVAL=
Port=
User=root
Pass=chenliang
Pid=/data/mysql//mysql.pid
Sock=/data/mysql//mysql.sock
My=/data/mysql//my.cnf
Path=/data/apps/mysql/bin

# Determine the user to execute
if [ $UID -ne $RETVAL ];then
    echo "Must be root to run scripts"
    exit
fi

# Load the local functions
[ -f /etc/init.d/functions ] && source /etc/init.d/functions

# Define functions
start(){
        if [ ! -f "$Pid" ];then
           $Path/mysqld_safe --defaults->& &
           RETVAL=$?
            ];then
              action "Start MySQL [3306]" /bin/true
             else
              action "Start MySQL [3306]" /bin/false
           fi
          else
           echo "MySQL 3306 is running"
           exit
       fi
       return $RETVAL
}

stop(){
        if [ -f "$Pid" ];then
           $Path/mysqladmin -u$User -p$Pass -S $Sock shutdown >/dev/>&
           RETVAL=$?
            ];then
              action "Stop MySQL[3306]" /bin/true
             else
              action "Stop MySQL[3306]" /bin/false
           fi
         else
           echo "MySQL [3306] is not running"
           exit
        fi
        return $RETVAL
}

status(){
        if [ -f "$Pid" ];then
            echo "MySQL [3306] is running"
           else
            echo "MySQL [3306] is not running"
        fi
        return $RETVAL
}

# Case call functions
case "$1" in
  start)
        start
        RETVAL=$?
        ;;
  stop)
        stop
        RETVAL=$?
        ;;
  restart)
        stop

        start
        RETVAL=$?
        ;;
  status)
        status
        RETVAL=$?
        ;;
  *)
        echo "USAGE:$0{start|stop|restart|status}"
        exit
esac

# Scripts return values
exit $RETVAL