Skip to content

Instantly share code, notes, and snippets.

@kix
Created July 12, 2011 06:26
Show Gist options
  • Save kix/1077500 to your computer and use it in GitHub Desktop.
Save kix/1077500 to your computer and use it in GitHub Desktop.
MySQL in RamFS second instance init script
#!/bin/sh -e
# RamFS stuff ===========================================================
#sudo su
if [ ! -d "/mnt/ram/mysql" ]; then
mkdir /mnt/ram/mysql
mkdir /etc/mysql2/
ln -s /mnt/ram/mysql/ /etc/mysql2/
cp -R /etc/mysql/* /etc/mysql2/
fi
if [ ! -d "/var/lib/mysql-2" ]; then
mkdir /var/lib/mysql-2
fi
if [ ! -d "/var/log/mysql-2" ]; then
mkdir /var/log/mysql-2
fi
if [ ! -d "/var/run/mysqld-2" ]; then
mkdir /var/run/mysqld-2
fi
chown mysql.mysql /var/lib/mysql-2
chown mysql.mysql /var/log/mysql-2
chown mysql.mysql /var/run/mysqld-2
cp /etc/mysql/my.cnf.mysql2 /etc/mysql2/my.cnf
mysql_install_db --user=mysql --datadir=/var/lib/mysql-2
# End RamFS stuff ======================================================
set -e
mysqld_safe --defaults-file=/etc/mysql2/my.cnf &
cat /home/kix/Code/struct.sql | mysql -S /var/run/mysqld-2/mysqld2.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment