Mount/Umount mysql databases into ramdisk

mountdb.sh

#!/bin/sh

#stop mysql service
service mysql stop

#mount ramdisk
mkdir -p /tmp/db_ramdisk
mount -t tmpfs -o size=512M tmpfs /tmp/db_ramdisk

#create back-up
cp -ra /var/lib/mysql /var/lib/mysql_bak
mv /var/lib/mysql /tmp/db_ramdisk/mysql
ln -s /tmp/db_ramdisk/mysql /var/lib/mysql

#change permissions for created link
sudo chmod -R 700 /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql

service mysql start

umountdb.sh

#!/bin/sh
#stop mysql service
service mysql stop

#remove link to mysql folder
rm -f /var/lib/mysql

#if copy of folder from ramdisk succeed then remove back-up, otherwise restore folder from back-up
if cp -ra /tmp/db_ramdisk/mysql /var/lib/mysql; then
	rm -rf /var/lib/mysql_bak
else
	rm -rf /var/lib/mysql
	cp -ra /var/lib/mysql_bak /var/lib/mysql
	rm -rf /var/lib/mysql_bak
fi

#start mysql service
service mysql start

#unmount ramdisk
umount /tmp/db_ramdisk