Skip to content

Instantly share code, notes, and snippets.

@brentertz
Created August 12, 2011 15:55
Show Gist options
  • Save brentertz/1142346 to your computer and use it in GitHub Desktop.
Save brentertz/1142346 to your computer and use it in GitHub Desktop.
For QuickLeft Blog Post on Heroku/Taps
$ heroku db:pull
...
Receiving schema
Schema: 100% |==========================================| Time: 00:00:00
Receiving indexes
users: 100% |==========================================| Time: 00:00:01
orders: 100% |==========================================| Time: 00:00:00
Receiving data
2 tables, 300 records
Resetting sequences
$ heroku db:pull --filter '^log_'
$ heroku db:pull sqlite://path_to_db/my.db
$ heroku db:pull --tables users,orders
$ heroku db:push
...
Sending schema
Schema: 100% |==========================================| Time: 00:00:01
Sending indexes
Sending data
2 tables, 300 records
users: 100% |==========================================| Time: 00:00:01
orders: 100% |==========================================| Time: 00:00:00
Resetting sequences
$ heroku db:push postgres://postgres:mypass@remotehost/mydb
$ gem install heroku
$ gem install taps
$ gem install taps
$ taps pull postgres://dbuser:dbpassword@localhost/dbname http://httpuser:[email protected]:5000
$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:[email protected]:5000
$ taps server postgres://localdbuser:localdbpass@localhost/dbname httpuser httppassword
== Sinatra/1.0 has taken the stage on 5000 for production with backup from WEBrick
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment