CODEWITHSUNDEEP
mysqldatabaseweb-applicationssshopenshift
andy007
andy007

Reputation: 917

Openshift: how import database to MySQL via RHC or SSH?

I have Openshift based scalable webapp with free account so I can't create phpmyadmin cartrige. Is there a way to import database to MySQL via RHC or SSH ?

Upvotes: 3

Views: 1567

Answers (1)

user2879327
user2879327

Reputation:

You have a couple of good options for doing this.

1.) You can use the rhc port-forward command to connect to your database from your local workstation, then you can use mysql workbench or the mysql command line tool on your local workstation to import the database.

2.) Use the rhc scp command to transfer your .sql file to your gear (place it in your $OPENSHIFT_DATA_DIR) and then use the rhc ssh command to connect to your gear and then use the mysql command line utility to import your database.

Upvotes: 4

Related Questions