tomykaira/my.cnf

## my.cnf
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password     = your_password
port          = 3306
socket          = /tmp/mysql5647.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user = mysql
basedir      = /usr/local/mysql-5.6.4-m7
datadir      = /usr/local/mysql-5.6.4-m7/data
port          = 3306
socket          = /tmp/mysql5647.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
default_storage_engine = InnoDB
character_set_server = utf8
collation_server = utf8_general_ci
max_connections = 64

query_cache_type = 1
query_cache_size = 1M

# file per table
innodb_file_per_table

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
#server-id     = 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

# binary logging format - mixed recommended
#binlog_format=mixed

# Causes updates to non-transactional engines using statement format to be
# written directly to binary log. Before using this option make sure that
# there are no dependencies between transactional and non-transactional
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
# t_innodb; otherwise, slaves may diverge from the master.
#binlog_direct_non_transactional_updates=TRUE

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 4M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 1M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 512K
sort_buffer_size = 512K

[mysqlhotcopy]
interactive-timeout

## mysql.server
#!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind

# MySQL daemon start/stop script.

# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
# When this is done the mysql server will be started when the machine is
# started and shut down when the systems goes down.

# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.

# Comments to support LSB init script conventions
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $local_fs $network $remote_fs
# Should-Start: ypbind nscd ldap ntpd xntpd
# Required-Stop: $local_fs $network $remote_fs
# Default-Start:  2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: start and stop MySQL
# Description: MySQL is a very fast and reliable SQL database engine.
### END INIT INFO

# If you install MySQL on some other places than /usr/local/mysql, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=/usr/local/mysql-5.6.4-m7
datadir=/usr/local/mysql-5.6.4-m7/data

# Default value, in seconds, afterwhich the script should timeout waiting
# for server start.
# Value here is overriden by value in my.cnf.
# 0 means don't wait at all
# Negative numbers mean to wait indefinitely
service_startup_timeout=900

# Lock directory for RedHat / SuSE.
lockdir='/var/lock/subsys'
lock_file_path="$lockdir/mysql"

# The following variables are only set for letting mysql.server find things.

# Set some defaults
mysqld_pid_file_path=
if test -z "$basedir"
then
  basedir=/usr/local/mysql
  bindir=/usr/local/mysql/bin
  if test -z "$datadir"
  then
    datadir=/usr/local/mysql/data
  fi
  sbindir=/usr/local/mysql/bin
  libexecdir=/usr/local/mysql/bin
else
  bindir="$basedir/bin"
  if test -z "$datadir"
  then
    datadir="$basedir/data"
  fi
  sbindir="$basedir/sbin"
  libexecdir="$basedir/libexec"
fi

# datadir_set is used to determine if datadir was set (and so should be
# *not* set inside of the --basedir= handler.)
datadir_set=

#
# Use LSB init script functions for printing messages, if possible
#
lsb_functions="/lib/lsb/init-functions"
if test -f $lsb_functions ; then
  . $lsb_functions
else
  log_success_msg()
  {
    echo " SUCCESS! $@"
  }
  log_failure_msg()
  {
    echo " ERROR! $@"
  }
fi

PATH="/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin"
export PATH

mode=$1    # start or stop

[ $# -ge 1 ] && shift


other_args="$*"   # uncommon, but needed when called from an RPM upgrade action
           # Expected: "--skip-networking --skip-grant-tables"
           # They are not checked here, intentionally, as it is the resposibility
           # of the "spec" file author to give correct arguments only.

case `echo "testing\c"`,`echo -n testing` in
    *c*,-n*) echo_n=   echo_c=     ;;
    *c*,*)   echo_n=-n echo_c=     ;;
    *)       echo_n=   echo_c='\c' ;;
esac

parse_server_arguments() {
  for arg do
    case "$arg" in
      --basedir=*)  basedir=`echo "$arg" | sed -e 's/^[^=]*=//'`
                    bindir="$basedir/bin"
              if test -z "$datadir_set"; then
                datadir="$basedir/data"
              fi
              sbindir="$basedir/sbin"
              libexecdir="$basedir/libexec"
        ;;
      --datadir=*)  datadir=`echo "$arg" | sed -e 's/^[^=]*=//'`
              datadir_set=1
     ;;
      --pid-file=*) mysqld_pid_file_path=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
      --service-startup-timeout=*) service_startup_timeout=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
    esac
  done
}

wait_for_pid () {
  verb="$1"           # created | removed
  pid="$2"            # process ID of the program operating on the pid-file
  pid_file_path="$3" # path to the PID file.

  i=0
  avoid_race_condition="by checking again"

  while test $i -ne $service_startup_timeout ; do

    case "$verb" in
      'created')
        # wait for a PID-file to pop into existence.
        test -s "$pid_file_path" && i='' && break
        ;;
      'removed')
        # wait for this PID-file to disappear
        test ! -s "$pid_file_path" && i='' && break
        ;;
      *)
        echo "wait_for_pid () usage: wait_for_pid created|removed pid pid_file_path"
        exit 1
        ;;
    esac

    # if server isn't running, then pid-file will never be updated
    if test -n "$pid"; then
      if kill -0 "$pid" 2>/dev/null; then
        :  # the server still runs
      else
        # The server may have exited between the last pid-file check and now.
        if test -n "$avoid_race_condition"; then
          avoid_race_condition=""
          continue  # Check again.
        fi

        # there's nothing that will affect the file.
        log_failure_msg "The server quit without updating PID file ($pid_file_path)."
        return 1  # not waiting any more.
      fi
    fi

    echo $echo_n ".$echo_c"
    i=`expr $i + 1`
    sleep 1

  done

  if test -z "$i" ; then
    log_success_msg
    return 0
  else
    log_failure_msg
    return 1
  fi
}

# Get arguments from the my.cnf file,
# the only group, which is read from now on is [mysqld]
if test -x ./bin/my_print_defaults
then
  print_defaults="./bin/my_print_defaults"
elif test -x $bindir/my_print_defaults
then
  print_defaults="$bindir/my_print_defaults"
elif test -x $bindir/mysql_print_defaults
then
  print_defaults="$bindir/mysql_print_defaults"
else
  # Try to find basedir in /etc/my.cnf
  conf=/etc/my.cnf
  echo $conf
  print_defaults=
  if test -r $conf
  then
    subpat='^[^=]*basedir[^=]*=\(.*\)$'
    dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
    for d in $dirs
    do
      d=`echo $d | sed -e 's/[      ]//g'`
      if test -x "$d/bin/my_print_defaults"
      then
        print_defaults="$d/bin/my_print_defaults"
        break
      fi
      if test -x "$d/bin/mysql_print_defaults"
      then
        print_defaults="$d/bin/mysql_print_defaults"
        break
      fi
    done
  fi

  # Hope it's in the PATH ... but I doubt it
  test -z "$print_defaults" && print_defaults="my_print_defaults"
fi

#
# Read defaults file from 'basedir'.   If there is no defaults file there
# check if it's in the old (depricated) place (datadir) and read it from there
#

extra_args=""
if test -r "$basedir/my.cnf"
then
  extra_args="-e $basedir/my.cnf"
else
  if test -r "$datadir/my.cnf"
  then
    extra_args="-e $datadir/my.cnf"
  fi
fi

# echo  `$print_defaults -c $basedir/my.cnf $extra_args mysqld server mysql_server mysql.server`
# this line is merged default config.
parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`
# parse_server_arguments `$print_defaults -c $basedir/my.cnf $extra_args mysqld server mysql_server mysql.server`

#
# Set pid file if not given
#
if test -z "$mysqld_pid_file_path"
then
  mysqld_pid_file_path=$datadir/`hostname`.pid
else
  case "$mysqld_pid_file_path" in
    /* ) ;;
    * )  mysqld_pid_file_path="$datadir/$mysqld_pid_file_path" ;;
  esac
fi

case "$mode" in
  'start')
    # Start daemon

    # Safeguard (relative paths, core dumps..)
    cd $basedir

    echo $echo_n "Starting MySQL"
    if test -x $bindir/mysqld_safe
    then
      ulimit -s 192
      # Give extra arguments to mysqld with the my.cnf file. This script
      # may be overwritten at next upgrade.
      $bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
      wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

      # Make lock for RedHat / SuSE
      if test -w "$lockdir"
      then
        touch "$lock_file_path"
      fi

      exit $return_value
    else
      log_failure_msg "Couldn't find MySQL server ($bindir/mysqld_safe)"
    fi
    ;;

  'stop')
    # Stop daemon. We use a signal here to avoid having to know the
    # root password.

    if test -s "$mysqld_pid_file_path"
    then
      mysqld_pid=`cat "$mysqld_pid_file_path"`

      if (kill -0 $mysqld_pid 2>/dev/null)
      then
        echo $echo_n "Shutting down MySQL"
        kill $mysqld_pid
        # mysqld should remove the pid file when it exits, so wait for it.
        wait_for_pid removed "$mysqld_pid" "$mysqld_pid_file_path"; return_value=$?
      else
        log_failure_msg "MySQL server process #$mysqld_pid is not running!"
        rm "$mysqld_pid_file_path"
      fi

      # Delete lock for RedHat / SuSE
      if test -f "$lock_file_path"
      then
        rm -f "$lock_file_path"
      fi
      exit $return_value
    else
      log_failure_msg "MySQL server PID file could not be found!"
    fi
    ;;

  'restart')
    # Stop the service and regardless of whether it was
    # running or not, start it again.
    if $0 stop  $other_args; then
      $0 start $other_args
    else
      log_failure_msg "Failed to stop running server, so refusing to try to start."
      exit 1
    fi
    ;;

  'reload'|'force-reload')
    if test -s "$mysqld_pid_file_path" ; then
      read mysqld_pid <  "$mysqld_pid_file_path"
      kill -HUP $mysqld_pid && log_success_msg "Reloading service MySQL"
      touch "$mysqld_pid_file_path"
    else
      log_failure_msg "MySQL PID file could not be found!"
      exit 1
    fi
    ;;
  'status')
    # First, check to see if pid file exists
    if test -s "$mysqld_pid_file_path" ; then
      read mysqld_pid < "$mysqld_pid_file_path"
      if kill -0 $mysqld_pid 2>/dev/null ; then
        log_success_msg "MySQL running ($mysqld_pid)"
        exit 0
      else
        log_failure_msg "MySQL is not running, but PID file exists"
        exit 1
      fi
    else
      # Try to find appropriate mysqld process
      mysqld_pid=`pidof $libexecdir/mysqld`
      if test -z $mysqld_pid ; then
        if test -f "$lock_file_path" ; then
          log_failure_msg "MySQL is not running, but lock file ($lock_file_path) exists"
          exit 2
        fi
        log_failure_msg "MySQL is not running"
        exit 3
      else
        log_failure_msg "MySQL is running but PID file could not be found"
        exit 4
      fi
    fi
    ;;
    *)
      # usage
      basename=`basename "$0"`
      echo "Usage: $basename  {start|stop|restart|reload|force-reload|status}  [ MySQL server options ]"
      exit 1
    ;;
esac

exit 0
	# Example MySQL config file for small systems.
	#
	# This is for a system with little memory (<= 64M) where MySQL is only used
	# from time to time and it's important that the mysqld daemon
	# doesn't use much resources.
	#
	# MySQL programs look for option files in a set of
	# locations which depend on the deployment platform.
	# You can copy this option file to one of those
	# locations. For information about these locations, see:
	# http://dev.mysql.com/doc/mysql/en/option-files.html
	#
	# In this file, you can use all long options that a program supports.
	# If you want to know which options a program supports, run the program
	# with the "--help" option.

	# The following options will be passed to all MySQL clients
	[client]
	#password = your_password
	port = 3306
	socket = /tmp/mysql5647.sock

	# Here follows entries for some specific programs

	# The MySQL server
	[mysqld]
	user = mysql
	basedir = /usr/local/mysql-5.6.4-m7
	datadir = /usr/local/mysql-5.6.4-m7/data
	port = 3306
	socket = /tmp/mysql5647.sock
	skip-external-locking
	key_buffer_size = 16K
	max_allowed_packet = 1M
	table_open_cache = 4
	sort_buffer_size = 64K
	read_buffer_size = 256K
	read_rnd_buffer_size = 256K
	net_buffer_length = 2K
	thread_stack = 128K
	default_storage_engine = InnoDB
	character_set_server = utf8
	collation_server = utf8_general_ci
	max_connections = 64

	query_cache_type = 1
	query_cache_size = 1M

	# file per table
	innodb_file_per_table

	# Don't listen on a TCP/IP port at all. This can be a security enhancement,
	# if all processes that need to connect to mysqld run on the same host.
	# All interaction with mysqld must be made via Unix sockets or named pipes.
	# Note that using this option without enabling named pipes on Windows
	# (using the "enable-named-pipe" option) will render mysqld useless!
	#
	#skip-networking
	#server-id = 1

	# Uncomment the following if you want to log updates
	#log-bin=mysql-bin

	# binary logging format - mixed recommended
	#binlog_format=mixed

	# Causes updates to non-transactional engines using statement format to be
	# written directly to binary log. Before using this option make sure that
	# there are no dependencies between transactional and non-transactional
	# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
	# t_innodb; otherwise, slaves may diverge from the master.
	#binlog_direct_non_transactional_updates=TRUE

	# Uncomment the following if you are using InnoDB tables
	#innodb_data_home_dir = /usr/local/mysql/data
	#innodb_data_file_path = ibdata1:10M:autoextend
	#innodb_log_group_home_dir = /usr/local/mysql/data
	# You can set .._buffer_pool_size up to 50 - 80 %
	# of RAM but beware of setting memory usage too high
	innodb_buffer_pool_size = 4M
	#innodb_additional_mem_pool_size = 2M
	# Set .._log_file_size to 25 % of buffer pool size
	innodb_log_file_size = 5M
	innodb_log_buffer_size = 1M
	#innodb_flush_log_at_trx_commit = 1
	#innodb_lock_wait_timeout = 50

	[mysqldump]
	quick
	max_allowed_packet = 16M

	[mysql]
	no-auto-rehash
	# Remove the next comment character if you are not familiar with SQL
	#safe-updates

	[myisamchk]
	key_buffer_size = 512K
	sort_buffer_size = 512K

	[mysqlhotcopy]
	interactive-timeout
	#!/bin/sh
	# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
	# This file is public domain and comes with NO WARRANTY of any kind

	# MySQL daemon start/stop script.

	# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
	# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
	# When this is done the mysql server will be started when the machine is
	# started and shut down when the systems goes down.

	# Comments to support chkconfig on RedHat Linux
	# chkconfig: 2345 64 36
	# description: A very fast and reliable SQL database engine.

	# Comments to support LSB init script conventions
	### BEGIN INIT INFO
	# Provides: mysql
	# Required-Start: $local_fs $network $remote_fs
	# Should-Start: ypbind nscd ldap ntpd xntpd
	# Required-Stop: $local_fs $network $remote_fs
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: start and stop MySQL
	# Description: MySQL is a very fast and reliable SQL database engine.
	### END INIT INFO

	# If you install MySQL on some other places than /usr/local/mysql, then you
	# have to do one of the following things for this script to work:
	#
	# - Run this script from within the MySQL installation directory
	# - Create a /etc/my.cnf file with the following information:
	# [mysqld]
	# basedir=<path-to-mysql-installation-directory>
	# - Add the above to any other configuration file (for example ~/.my.ini)
	# and copy my_print_defaults to /usr/bin
	# - Add the path to the mysql-installation-directory to the basedir variable
	# below.
	#
	# If you want to affect other MySQL variables, you should make your changes
	# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

	# If you change base dir, you must also change datadir. These may get
	# overwritten by settings in the MySQL configuration files.

	basedir=/usr/local/mysql-5.6.4-m7
	datadir=/usr/local/mysql-5.6.4-m7/data

	# Default value, in seconds, afterwhich the script should timeout waiting
	# for server start.
	# Value here is overriden by value in my.cnf.
	# 0 means don't wait at all
	# Negative numbers mean to wait indefinitely
	service_startup_timeout=900

	# Lock directory for RedHat / SuSE.
	lockdir='/var/lock/subsys'
	lock_file_path="$lockdir/mysql"

	# The following variables are only set for letting mysql.server find things.

	# Set some defaults
	mysqld_pid_file_path=
	if test -z "$basedir"
	then
	basedir=/usr/local/mysql
	bindir=/usr/local/mysql/bin
	if test -z "$datadir"
	then
	datadir=/usr/local/mysql/data
	fi
	sbindir=/usr/local/mysql/bin
	libexecdir=/usr/local/mysql/bin
	else
	bindir="$basedir/bin"
	if test -z "$datadir"
	then
	datadir="$basedir/data"
	fi
	sbindir="$basedir/sbin"
	libexecdir="$basedir/libexec"
	fi

	# datadir_set is used to determine if datadir was set (and so should be
	# not set inside of the --basedir= handler.)
	datadir_set=

	#
	# Use LSB init script functions for printing messages, if possible
	#
	lsb_functions="/lib/lsb/init-functions"
	if test -f $lsb_functions ; then
	. $lsb_functions
	else
	log_success_msg()
	{
	echo " SUCCESS! $@"
	}
	log_failure_msg()
	{
	echo " ERROR! $@"
	}
	fi

	PATH="/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin"
	export PATH

	mode=$1 # start or stop

	[ $# -ge 1 ] && shift


	other_args="$*" # uncommon, but needed when called from an RPM upgrade action
	# Expected: "--skip-networking --skip-grant-tables"
	# They are not checked here, intentionally, as it is the resposibility
	# of the "spec" file author to give correct arguments only.

	case `echo "testing\c"`,`echo -n testing` in
	c,-n*) echo_n= echo_c= ;;
	c,*) echo_n=-n echo_c= ;;
	*) echo_n= echo_c='\c' ;;
	esac

	parse_server_arguments() {
	for arg do
	case "$arg" in
	--basedir=) basedir=`echo "$arg" \| sed -e 's/^[^=]=//'`
	bindir="$basedir/bin"
	if test -z "$datadir_set"; then
	datadir="$basedir/data"
	fi
	sbindir="$basedir/sbin"
	libexecdir="$basedir/libexec"
	;;
	--datadir=) datadir=`echo "$arg" \| sed -e 's/^[^=]=//'`
	datadir_set=1
	;;
	--pid-file=) mysqld_pid_file_path=`echo "$arg" \| sed -e 's/^[^=]=//'` ;;
	--service-startup-timeout=) service_startup_timeout=`echo "$arg" \| sed -e 's/^[^=]=//'` ;;
	esac
	done
	}

	wait_for_pid () {
	verb="$1" # created \| removed
	pid="$2" # process ID of the program operating on the pid-file
	pid_file_path="$3" # path to the PID file.

	i=0
	avoid_race_condition="by checking again"

	while test $i -ne $service_startup_timeout ; do

	case "$verb" in
	'created')
	# wait for a PID-file to pop into existence.
	test -s "$pid_file_path" && i='' && break
	;;
	'removed')
	# wait for this PID-file to disappear
	test ! -s "$pid_file_path" && i='' && break
	;;
	*)
	echo "wait_for_pid () usage: wait_for_pid created\|removed pid pid_file_path"
	exit 1
	;;
	esac

	# if server isn't running, then pid-file will never be updated
	if test -n "$pid"; then
	if kill -0 "$pid" 2>/dev/null; then
	: # the server still runs
	else
	# The server may have exited between the last pid-file check and now.
	if test -n "$avoid_race_condition"; then
	avoid_race_condition=""
	continue # Check again.
	fi

	# there's nothing that will affect the file.
	log_failure_msg "The server quit without updating PID file ($pid_file_path)."
	return 1 # not waiting any more.
	fi
	fi

	echo $echo_n ".$echo_c"
	i=`expr $i + 1`
	sleep 1

	done

	if test -z "$i" ; then
	log_success_msg
	return 0
	else
	log_failure_msg
	return 1
	fi
	}

	# Get arguments from the my.cnf file,
	# the only group, which is read from now on is [mysqld]
	if test -x ./bin/my_print_defaults
	then
	print_defaults="./bin/my_print_defaults"
	elif test -x $bindir/my_print_defaults
	then
	print_defaults="$bindir/my_print_defaults"
	elif test -x $bindir/mysql_print_defaults
	then
	print_defaults="$bindir/mysql_print_defaults"
	else
	# Try to find basedir in /etc/my.cnf
	conf=/etc/my.cnf
	echo $conf
	print_defaults=
	if test -r $conf
	then
	subpat='^[^=]basedir[^=]=\(.*\)$'
	dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
	for d in $dirs
	do
	d=`echo $d \| sed -e 's/[ ]//g'`
	if test -x "$d/bin/my_print_defaults"
	then
	print_defaults="$d/bin/my_print_defaults"
	break
	fi
	if test -x "$d/bin/mysql_print_defaults"
	then
	print_defaults="$d/bin/mysql_print_defaults"
	break
	fi
	done
	fi

	# Hope it's in the PATH ... but I doubt it
	test -z "$print_defaults" && print_defaults="my_print_defaults"
	fi

	#
	# Read defaults file from 'basedir'. If there is no defaults file there
	# check if it's in the old (depricated) place (datadir) and read it from there
	#

	extra_args=""
	if test -r "$basedir/my.cnf"
	then
	extra_args="-e $basedir/my.cnf"
	else
	if test -r "$datadir/my.cnf"
	then
	extra_args="-e $datadir/my.cnf"
	fi
	fi

	# echo `$print_defaults -c $basedir/my.cnf $extra_args mysqld server mysql_server mysql.server`
	# this line is merged default config.
	parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`
	# parse_server_arguments `$print_defaults -c $basedir/my.cnf $extra_args mysqld server mysql_server mysql.server`

	#
	# Set pid file if not given
	#
	if test -z "$mysqld_pid_file_path"
	then
	mysqld_pid_file_path=$datadir/`hostname`.pid
	else
	case "$mysqld_pid_file_path" in
	/* ) ;;
	* ) mysqld_pid_file_path="$datadir/$mysqld_pid_file_path" ;;
	esac
	fi

	case "$mode" in
	'start')
	# Start daemon

	# Safeguard (relative paths, core dumps..)
	cd $basedir

	echo $echo_n "Starting MySQL"
	if test -x $bindir/mysqld_safe
	then
	ulimit -s 192
	# Give extra arguments to mysqld with the my.cnf file. This script
	# may be overwritten at next upgrade.
	$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
	wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

	# Make lock for RedHat / SuSE
	if test -w "$lockdir"
	then
	touch "$lock_file_path"
	fi

	exit $return_value
	else
	log_failure_msg "Couldn't find MySQL server ($bindir/mysqld_safe)"
	fi
	;;

	'stop')
	# Stop daemon. We use a signal here to avoid having to know the
	# root password.

	if test -s "$mysqld_pid_file_path"
	then
	mysqld_pid=`cat "$mysqld_pid_file_path"`

	if (kill -0 $mysqld_pid 2>/dev/null)
	then
	echo $echo_n "Shutting down MySQL"
	kill $mysqld_pid
	# mysqld should remove the pid file when it exits, so wait for it.
	wait_for_pid removed "$mysqld_pid" "$mysqld_pid_file_path"; return_value=$?
	else
	log_failure_msg "MySQL server process #$mysqld_pid is not running!"
	rm "$mysqld_pid_file_path"
	fi

	# Delete lock for RedHat / SuSE
	if test -f "$lock_file_path"
	then
	rm -f "$lock_file_path"
	fi
	exit $return_value
	else
	log_failure_msg "MySQL server PID file could not be found!"
	fi
	;;

	'restart')
	# Stop the service and regardless of whether it was
	# running or not, start it again.
	if $0 stop $other_args; then
	$0 start $other_args
	else
	log_failure_msg "Failed to stop running server, so refusing to try to start."
	exit 1
	fi
	;;

	'reload'\|'force-reload')
	if test -s "$mysqld_pid_file_path" ; then
	read mysqld_pid < "$mysqld_pid_file_path"
	kill -HUP $mysqld_pid && log_success_msg "Reloading service MySQL"
	touch "$mysqld_pid_file_path"
	else
	log_failure_msg "MySQL PID file could not be found!"
	exit 1
	fi
	;;
	'status')
	# First, check to see if pid file exists
	if test -s "$mysqld_pid_file_path" ; then
	read mysqld_pid < "$mysqld_pid_file_path"
	if kill -0 $mysqld_pid 2>/dev/null ; then
	log_success_msg "MySQL running ($mysqld_pid)"
	exit 0
	else
	log_failure_msg "MySQL is not running, but PID file exists"
	exit 1
	fi
	else
	# Try to find appropriate mysqld process
	mysqld_pid=`pidof $libexecdir/mysqld`
	if test -z $mysqld_pid ; then
	if test -f "$lock_file_path" ; then
	log_failure_msg "MySQL is not running, but lock file ($lock_file_path) exists"
	exit 2
	fi
	log_failure_msg "MySQL is not running"
	exit 3
	else
	log_failure_msg "MySQL is running but PID file could not be found"
	exit 4
	fi
	fi
	;;
	*)
	# usage
	basename=`basename "$0"`
	echo "Usage: $basename {start\|stop\|restart\|reload\|force-reload\|status} [ MySQL server options ]"
	exit 1
	;;
	esac

	exit 0