Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
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
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
Copy link

edenir-anschau commented Jan 25, 2016


Copy link

ramrumram commented Feb 16, 2016

thank you

Copy link

diegobabativa commented Feb 16, 2016

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

Copy link

oing9179 commented Jul 20, 2016

This is definitely helpful, thank you.

Copy link

gautamkrishnar commented Jul 31, 2016

Thanks a lot 😄

Copy link

Ashaba commented Aug 29, 2016

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

Copy link

danielcooperxyz commented Nov 3, 2016

Copy link

siripuramrk commented Dec 24, 2016

Thank you.

Copy link

BillRizer commented Mar 8, 2017

Thanks :)

Copy link

ashim888 commented Sep 30, 2017


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment