Sandstorm Firefly to Standalone

Tested on Ubuntu 19.10

1) Install Docker, zip, unzip

sudo su

snap install docker

apt-get install zip unzip

2) Copy Sandstorm Firefly files

• firefly.zip is Firefly grain you downloaded with arrow down button at Sandstorm
• /home/user is your user directory, could be different
• /data is where firefly files are copied, and used inside Docker MySQL 5.5. You could rename it to some other name, if you have something else at that directory.
• firefly.sql is MySQL dump of the Firefly database

cd /home/user/Downloads

unzip firefly.zip

chown -R 1000:1000 data

mv data /

cd /

3) Start MySQL 5.5 in Docker and create database dump

docker run -v "/data/lib/mysql":/var/lib/mysql --user 1000:1000 --name my -e MYSQL_ROOT_PASSWORD=firefly -d mysql:5.5

docker exec -it my bash

cd /tmp

mysqldump -ufirefly -pfirefly firefly > firefly.sql

exit

4) Copy files from inside of Docker to outside

docker cp my:/tmp/firefly.sql .

chown user:user firefly.sql

mv firefly.sql /home/user/Downloads/

5) Cleanup

docker stop my

docker rm my

rm -rf data