Skip to content

Instantly share code, notes, and snippets.

@bradfordpythian
Last active February 3, 2017 15:20
Show Gist options
  • Save bradfordpythian/8bee946bb1fa258f6b1d07352c15a7cd to your computer and use it in GitHub Desktop.
Save bradfordpythian/8bee946bb1fa258f6b1d07352c15a7cd to your computer and use it in GitHub Desktop.
MySQL Sandbox Setup
#
# Setup of MySQL Sandbox via git repo
#
[ -d mysql-sandbox ] && cd mysql-sandbox && git pull & cd ..
[ ! -d mysql-sandbox ] && git clone https://github.com/datacharmer/mysql-sandbox.git
cd mysql-sandbox
echo "perl Makefile.PL
make
make test
make install" > install.sh
chmod +x install.sh
sudo ./install.sh
make_sandbox --help | head -2
# The MySQL Sandbox, version 3.2.05
# (C) 2006-2016 Giuseppe Maxia
#
# Download of current MySQL binaries
#
# See http://downloads.mysql.com/archives/community/
cd /tmp
wget http://downloads.mysql.com/archives/get/file/mysql-5.0.96-linux-x86_64-glibc23.tar.gz
wget http://downloads.mysql.com/archives/get/file/mysql-5.1.72-linux-x86_64-glibc23.tar.gz
wget http://downloads.mysql.com/archives/get/file/mysql-5.5.52-linux2.6-x86_64.tar.gz
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
wget http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz
wget http://mirror.lstn.net/mariadb//mariadb-10.0.29/bintar-linux-x86_64/mariadb-10.0.29-linux-x86_64.tar.gz
#
# Required dependency for MySQL 5.6+
#
sudo apt-get install libaio1
sudo mkdir -p /opt/mysql
for VERSION in `echo "5.0.96 5.1.72 5.5.52 5.6.35 5.7.17 8.0.0"`
do
echo "Extracting version ${VERSION}"
sudo tar Cxfz /opt/mysql mysql-${VERSION}-*.tar.gz
sudo mv /opt/mysql/*${VERSION}* /opt/mysql/${VERSION}
done
#sudo tar xvfz mariadb-10.0.29-linux-x86_64.tar.gz
#sudo mv mariadb-10.0.29-linux-x86_64 mariadb-10.0.29
sudo rm -rf /opt/mysql/*/mysql-test
ls -l /opt/mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment