In OpenShift, a scaled application will have numerous 'gears', each running a copy of the developer's code. If the developer is running a database, there will be only one gear containing this database.

To export/import/backup/restore the database, a user must ssh to the specific gear that holds the database cartridge. The only current way to do this in JBDS is to print all the environment variables and look for the following:

$OPENSHIFT_MYSQL_DB_GEAR_UUID
$OPENSHIFT_MYSQL_DB_GEAR_DNS

You can then use these values in a terminal to ssh to the database gear:

$ ssh $OPENSHIFT_MYSQL_DB_GEAR_UUID@$OPENSHIFT_MYSQL_DB_GEAR_DNS

It would be helpful to have some kind of tooling to either ssh into this gear directly through JBDS, or at least print the ssh command (above) using the environment variables from the gear.