The following "pull" would have worked just fine if I had just pulled from both computers (I was basically trying to pull the dev site in from one computer to another):
From the "Pulling Computer", I created a directory to pull the heroku app into and then did the following (of course assuming there's already a heroku application deployed):
$ ssh-keygen -t rsa
$ sudo port selfupdate
$ heroku info --app nicodotti
=== nicodotti
...etc.
$ git clone -o heroku git@heroku.com:nicodotti.git (assumes git already installed of course
$ sudo gem install taps (heroku uses this for import/exporting dbs)
--> So from the other computer I did a db:push. I should have just pulled to it as well. What I essentially did, was overwrote my live site with the test database! <--
$ heroku db:pull
Auto-detected local database: sqlite://db/development.sqlite3
Receiving schema
Receiving data
8 tables, 31 records
comments: 100% |==========================================| Time: 00:00:00
taggings: 100% |==========================================| Time: 00:00:01
users: 100% |==========================================| Time: 00:00:00
authors: 100% |==========================================| Time: 00:00:00
schema_migrat: 100% |==========================================| Time: 00:00:00
tags: 100% |==========================================| Time: 00:00:00
rates: 100% |==========================================| Time: 00:00:00
posts: 100% |==========================================| Time: 00:00:00
Receiving indexes
Resetting sequences
Basically all of the above worked great. It's from the "pushing" computer that I screwed things up by doing the db:push ;)
So I'm learning Git and Heroku and accidentally overwrote the database on my server with my local test data! It's good I only wrote a couple of articles so far ;)
My blunder was that I did a db:push thinking that it would only push out the dev database (there's also a production database). In any event, I lost to two "real" articles I've created. No big deal. This site is primarily for learning Ruby on Rails, Git/Heroku, etc.
- Rob