CODEWITHSUNDEEP
mysqlheroku
Abhishek
Abhishek

Reputation: 1837

How to push my Mysql database to heroku via mysql workbench?

I have created cleardb on heroku, I want to push my mysql database on local disk to heroku. I have mysql workbench installed. How can i push it to heroku ?

Upvotes: 0

Views: 2411

Answers (2)

iujlaki
iujlaki

Reputation: 11

If u want to just push your database, use console, it's simple: 

heroku db:push

Upvotes: 0

John Beynon
John Beynon

Reputation: 37507

look at the output of heroku config - you will see an key called CLEARDB_DATABASE_URL this is the connection string your application uses to talk to your database.

You can take this URL and break it up into it's constituent parts to get a username, password, host, port and database name which you can use in a connection via mysql workbench.

See https://devcenter.heroku.com/articles/cleardb for further reference.

Upvotes: 1

Related Questions