Skip to content

Instantly share code, notes, and snippets.

@cbfrance
Created May 1, 2011 23:13
Show Gist options
  • Save cbfrance/950973 to your computer and use it in GitHub Desktop.
Save cbfrance/950973 to your computer and use it in GitHub Desktop.
I think this convenience of moving databases with a one-liner is one of the things that made web development the most fun in 2010. I do this every day in ruby (taps gem and heroku gem) and php (drush).
[[email protected] ~/git/meedan-dev]
[(master)] >
$ heroku db:pull
Loaded Taps v0.3.23
Auto-detected local database: sqlite://db/development.sqlite3
Warning: Data in the database 'sqlite://db/development.sqlite3' will be overwritten and will not be recoverable.
! WARNING: Potentially Destructive Action
! This command will affect the app: meedan-dev
! To proceed, type "meedan-dev" or re-run this command with --confirm meedan-dev
> meedan-dev
Receiving schema
Schema: 100% |==========================================| Time: 00:00:31
Receiving indexes
blog_posts: 100% |==========================================| Time: 00:00:00
page_translat: 100% |==========================================| Time: 00:00:00
user_plugins: 100% |==========================================| Time: 00:00:01
refinery_sett: 100% |==========================================| Time: 00:00:00
schema_migrat: 100% |==========================================| Time: 00:00:00
pages: 100% |==========================================| Time: 00:00:04
page_parts: 100% |==========================================| Time: 00:00:01
blog_categori: 100% |==========================================| Time: 00:00:00
users: 100% |==========================================| Time: 00:00:00
page_part_tra: 100% |==========================================| Time: 00:00:00
roles_users: 100% |==========================================| Time: 00:00:01
blog_categori: 100% |==========================================| Time: 00:00:00
seo_meta: 100% |==========================================| Time: 00:00:01
blog_comments: 100% |==========================================| Time: 00:00:00
slugs: 100% |==========================================| Time: 00:00:02
Receiving data
18 tables, 3,600 records
blog_posts: 100% |==========================================| Time: 00:00:01
page_translat: 100% |==========================================| Time: 00:00:00
schema_migrat: 100% |==========================================| Time: 00:00:00
user_plugins: 100% |==========================================| Time: 00:00:01
refinery_sett: 100% |==========================================| Time: 00:00:01
resources: 100% |==========================================| Time: 00:00:00
pages: 100% |==========================================| Time: 00:00:01
images: 100% |==========================================| Time: 00:00:00
page_parts: 100% |==========================================| Time: 00:00:01
blog_categori: 100% |==========================================| Time: 00:00:00
users: 100% |==========================================| Time: 00:00:00
page_part_tra: 100% |==========================================| Time: 00:00:01
roles_users: 100% |==========================================| Time: 00:00:00
seo_meta: 100% |==========================================| Time: 00:00:00
blog_categori: 100% |==========================================| Time: 00:00:00
roles: 100% |==========================================| Time: 00:00:00
blog_comments: 100% |==========================================| Time: 00:00:01
slugs: 100% |==========================================| Time: 00:00:00
Resetting sequences
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment