mysql and tmpfs

:/etc/init.d$ cat mysql-tmpfs


#!/bin/bash
#
### BEGIN INIT INFO
# Provides:          mysql-tmpfs
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Required-Start:
# Required-Stop:
# Short-Description: Create the mysql work environment at startup
# Description:       Create the links to hdd and the needed tmpfs files.
### END INIT INFO

#
# main()
#
case "${1:-''}" in
  'start')
   # load /var/lib/mysql from /permanent/mysql/lib/mysql
   /usr/bin/rsync -ArpEogt --delete /permanent/mysql/lib/mysql /var/lib
   # create the /var/run/mysql/... needed by mysql
   mkdir /var/run/mysqld
   chown mysql:root /var/run/mysqld
   #create the mysql-bin.log
   mkdir /var/log/mysql
   touch /var/log/mysql/mysql-bin.log
   chown mysql:root /var/log/mysql
   chown mysql:root /var/log/mysql/mysql-bin.log
   ;;
  'stop')
   if [ ! -d /permanent/mysql ] ; then mkdir /permanent/mysql ; fi
   # unload /var/lib/mysql to /permanent/mysql/lib/mysql
   if [ ! -d /permanent/mysql/lib ] ; then mkdir /permanent/mysql/lib ; fi
   /usr/bin/rsync -ArpEogt --delete /var/lib/mysql /permanent/mysql/lib
   ;;
  'restart')
   ;;
  'reload'|'force-reload')
   ;;
  'status')
   ;;
  *)
   echo "Usage: $SELF start|stop"
   exit 1
   ;;
esac