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

mysqlbackup.sh

#!/bin/sh

mkdir -p $OPENSHIFT_DATA_DIR/tmp/csv
chmod ugo+r $OPENSHIFT_DATA_DIR/tmp/csv
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 --single-transaction -r $OPENSHIFT_DATA_DIR/tmp/all-databases.sql
mysqldump -h $OPENSHIFT_MYSQL_DB_HOST -P ${OPENSHIFT_MYSQL_DB_PORT:-3306} -u ${OPENSHIFT_MYSQL_DB_USERNAME:-'admin'} --password="$OPENSHIFT_MYSQL_DB_PASSWORD" --databases $OPENSHIFT_APP_NAME --single-transaction -r $OPENSHIFT_DATA_DIR/tmp/$OPENSHIFT_APP_NAME.sql
mysqldump -h $OPENSHIFT_MYSQL_DB_HOST -P ${OPENSHIFT_MYSQL_DB_PORT:-3306} -u ${OPENSHIFT_MYSQL_DB_USERNAME:-'admin'} --password="$OPENSHIFT_MYSQL_DB_PASSWORD" --databases $OPENSHIFT_APP_NAME --single-transaction --routines=0 --triggers=0 --events=0 -r $OPENSHIFT_DATA_DIR/tmp/$OPENSHIFT_APP_NAME-no-procedures.sql
mysqldump -h $OPENSHIFT_MYSQL_DB_HOST -P ${OPENSHIFT_MYSQL_DB_PORT:-3306} -u ${OPENSHIFT_MYSQL_DB_USERNAME:-'admin'} --password="$OPENSHIFT_MYSQL_DB_PASSWORD" --databases $OPENSHIFT_APP_NAME --single-transaction --routines --triggers --events --no-create-info --no-data --no-create-db --skip-opt --single-transaction -r $OPENSHIFT_DATA_DIR/tmp/$OPENSHIFT_APP_NAME-routines-and-triggers.sql
mysqldump -h $OPENSHIFT_MYSQL_DB_HOST -P ${OPENSHIFT_MYSQL_DB_PORT:-3306} -u ${OPENSHIFT_MYSQL_DB_USERNAME:-'admin'} --password="$OPENSHIFT_MYSQL_DB_PASSWORD" -T $OPENSHIFT_DATA_DIR/tmp/csv $OPENSHIFT_APP_NAME --fields-terminated-by=, --fields-enclosed-by='"' --lines-terminated-by=0x0d0a --single-transaction
tar -zcvf ~/app-root/data/backup.tar.gz ~/app-root/data/tmp