Skip to content

Instantly share code, notes, and snippets.

@kurisuchan

kurisuchan/gist:1262135

Created October 4, 2011 16:43
Show Gist options
  • Save kurisuchan/1262135 to your computer and use it in GitHub Desktop.
Save kurisuchan/1262135 to your computer and use it in GitHub Desktop.
Download ZIP
Moving MySQL databases to ramdisk on Ubuntu
Raw
gistfile1.sh
# Tweaked from http://tomislavsantek.iz.hr/2011/03/moving-mysql-databases-to-ramdisk-in-ubuntu-linux
# Log in as root
# Mount ramdisk folder in RAM
mkdir /tmp/ramdisk
mount -t tmpfs -o size=128M tmpfs /tmp/ramdisk/
# Move MySQL data
mv /var/lib/mysql /tmp/ramdisk/mysql
ln -s /tmp/ramdisk/mysql/ /var/lib/mysql
# Update permissions
chmod -R 700 /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
restart mysql
@a2moosh
Copy link

a2moosh commented Aug 20, 2015

congrats, I would recommend a reboot after setting up the database that way ^^ ... not!

@foton
Copy link

foton commented Jan 11, 2017

You can even export just one schema (subfolder)! Apparmor must be modified.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment