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

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

I was trying all ways, but now it works, Thank you so much !

This is definitely helpful, thank you.

Thanks a lot 😄

what could have gone wrong?
bash: rms.sql: Permission denied

Openshift recommend $OPENSHIFT_TMP_DIR

https://developers.openshift.com/managing-your-applications/filesystem.html#tmp

Works!
Thank you.

Thanks :)

Great