Skip to content

Instantly share code, notes, and snippets.

@medyo

medyo/auto_backup.sh

Last active June 5, 2017 02:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save medyo/638bc1be401ec9d1d2f35eefdc26be41 to your computer and use it in GitHub Desktop.
Save medyo/638bc1be401ec9d1d2f35eefdc26be41 to your computer and use it in GitHub Desktop.
Download ZIP
Auto Backup Openshift Database, Full tutorial: http://medyo.github.io/2017/backup-openshift-database/
Raw
auto_backup.sh
#!/bin/bash
NOW="$(date +"%Y-%m-%d")"
FILENAME=$OPENSHIFT_APP_NAME.$NOW.backup.sql.gz
DATABASE_PATH=$OPENSHIFT_DATA_DIR/db_backups/$FILENAME
# Create db_backups folder if not existing
cd $OPENSHIFT_DATA_DIR && mkdir -p db_backups && cd db_backups
# Dump the postgresql database (for Mysql database, check the bottom of this page)
/opt/rh/postgresql92/root/usr/bin/pg_dump -h $OPENSHIFT_POSTGRESQL_DB_HOST -p $OPENSHIFT_POSTGRESQL_DB_PORT -F c $OPENSHIFT_APP_NAME > $FILENAME
# Upload the database using dropbox uploader
$OPENSHIFT_DATA_DIR/dropbox_uploader.sh upload $DATABASE_PATH $FILENAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment