MySQL in ram with ubuntu

mysql-ram.sh

#!/bin/bash

function quit {
    echo "Umounting temp"
    cd /
    umount /media/tmp
}

trap quit SIGINT

if [ "$(whoami)" != "root" ]
then
    sudo "$(readlink -f "$0")"
    exit 0
fi

if [ ! -d /media/tmp ]
then
    mkdir /media/tmp
fi

mount -t tmpfs tmpfs /media/tmp -rw
chmod 777 -R /media/tmp/
rsync -av /var/lib/mysql/ /media/tmp/

if [ -f /var/run/mysqld/mysqld.pid ]; then
    kill $(cat /var/run/mysqld/mysqld.pid)
    rm /var/run/mysqld/mysqld.pid
fi

cd /media/tmp
mysqld -h/media/tmp/
quit