Nico Dotti's Blog

>>a.k.a. roblevin || linjava<<

How I blew up my Heroku database!

Posted by: R. Levin on September 27, 2009 at 02:12PM    Show

Avatar

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 ;)

Blew Up My Database!

Posted by: R. Levin on September 27, 2009 at 02:08PM    Show

Avatar

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