Skip to content

Instantly share code, notes, and snippets.

@mikenoethiger
Created February 13, 2020 13:58
Show Gist options
  • Save mikenoethiger/469163db84b179d7ad63c0ba7efa71db to your computer and use it in GitHub Desktop.
Save mikenoethiger/469163db84b179d7ad63c0ba7efa71db to your computer and use it in GitHub Desktop.
Shell script that creates an sql dump after a db has been created and augmented by a java program
#!/bin/bash
# Add java and gradle to path variable
export JAVA_HOME=/opt/java/openjdk
export GRADLE_HOME=/opt/gradle
export PATH=$PATH:$JAVA_HOME/bin:$GRADLE_HOME/bin
# Start MySQL server in background
docker-entrypoint.sh mysqld &
# Give MySQL server time to boot
sleep 15
# Execute initial.sql on the DB
mysql -h127.0.0.1 -uroot -proot < initial.sql
# Execute java program that will augment data
cd java-program && gradle run && cd ..
# Dump the whole db into a compressed, single file
mysqldump -h127.0.0.1 -uroot -proot --databases schema1 schema2 | gzip -9 -c > dump.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment