Skip to content

Instantly share code, notes, and snippets.

@edenir-anschau

edenir-anschau/mysqlbackup.sh

Forked from nicdoye/mysqlbackup.sh
Last active August 29, 2015 14:28
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 edenir-anschau/c92a256052bd789068a7 to your computer and use it in GitHub Desktop.
Save edenir-anschau/c92a256052bd789068a7 to your computer and use it in GitHub Desktop.
Download ZIP
Backup your OpenShift MySQL database. My DB is only small so I didn't bother to compress it through a pipe. sftp it back from your local machine afterwards This is basically a quick hack from running "type mysql" on the OpenShift gear - hint: it's a bash function/alias
Raw
mysqlbackup.sh
mkdir ~/app-root/data/tmp
mysqldump -h $OPENSHIFT_MYSQL_DB_HOST -P ${OPENSHIFT_MYSQL_DB_PORT:-3306} -u ${OPENSHIFT_MYSQL_DB_USERNAME:-'admin'} --password="$OPENSHIFT_MYSQL_DB_PASSWORD" --all-databases > ~/app-root/data/tmp//all.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment