Maybe heroku db:push would do that? but its one off as it would scrap all data on server.
On 9 Dec 2010, at 2:51 AM, Zach Bailey wrote: > I'm wondering if anyone has had experience importing a large amount of data > into their heroku database and how they went about doing it. I'm staring down > about 3-4M rows of (static) data that I'd like to get into our DB on Heroku. > > > If I had my own database locally I would probably use the COPY command as it > is blazing fast. Inserting a row at a time from ruby code or going through an > exposed API is looking like it will take multiple days to do (without > spending extra money to crank up more dynos and buy a larger DB option) > > > Another option I thought of would be to figure out a way to load the data in > a local db then dump only that table and restore it into the heroku db as a > partial backup, but I didn't see any facility for that. > > > Has anyone done anything like this or think of a good way for doing it? > > > Thanks, > Zach > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
