If you want to make a backup of your database or just want to create a dump to migrate your db to another provider, you need to do these steps: 1. Connect to your running application trough SSH. To do that you need to click this link on OpenShift and run the displayed command. 2. Create the dump using this command:
1 2 |
mysqldump -u $OPENSHIFT_MYSQL_DB_USERNAME -h $OPENSHIFT_MYSQL_DB_HOST --password=$OPENSHIFT_MYSQL_DB_PASSWORD $OPENSHIFT_GEAR_NAME > dump.sql gzip dump.sql |
3. After that you can scp the dump to any location you want.