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

martinbrambati commented Jan 21, 2014

Great man! thanks!

Copy link

pengjiayou commented May 17, 2015

Great, thanks.

Copy link

souvikbasu commented Jun 4, 2015


Copy link

weplan9 commented Jun 24, 2015


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