Created
February 13, 2020 13:58
-
-
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/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