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 ?
1
-
possible duplicate of How do I push my mysql database from phpmyadmin to heroku's cleardb?catsby– catsby2013-04-03 14:52:21 +00:00Commented Apr 3, 2013 at 14:52
Add a comment
|
2 Answers
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.
If u want to just push your database, use console, it's simple:
heroku db:push
3 Comments
Abhishek
How can I get one console on my windows running? I have always worked with phpmyadmin in wamp server
iujlaki
E.g if you use TotalCommander then navigate to the root directory of your app. Type cmd and press enter. You will get a console. Maybe you have to install heroku toolbelt. toolbelt.heroku.com
Mikael Kessler
This feature has been deprecated - blog.heroku.com/archives/2009/3/18/….