I believe you might be looking for yaml_db, which will dump all the data to a yaml file.
http://github.com/adamwiggins/yaml_db I forked this to add the ability to specify the output file and selectively choose the tables to export: http://github.com/hopeless/yaml_db However, it was a bit of a rush job last year so let me know if it works for you Jamie On Jan 28, 5:43 pm, Ed Jones <[email protected]> wrote: > Thanks, Doug. > > It's that "extract your development seed data into a yaml file if > necessary in order to do the initial import on > heroku" that I've lost track of how to do. Used to be easy and well > documented. I've searched for three days now. > > I just want to upload one table!! :-) > > e > > On Jan 25, 3:40 pm, Doug Petkanics <[email protected]> wrote: > > > Ed, > > > Someone else can chime in if there is actually a way to do a heroku db:push > > for a restricted set of tables (I don't think there is). You may want to > > look into creating the new tables using a migration and seeding them using > > the technique described in this > > post:http://derekdevries.com/2009/04/13/rails-seed-data/ > > > It's relatively straightforward, and you can extract your development seed > > data into a yaml file if necessary in order to do the initial import on > > heroku. > > > -Doug > > > On Mon, Jan 25, 2010 at 3:31 PM, Ed Jones <[email protected]> wrote: > > > Thanks matt. > > > > How do you just load say 3 of 8 tables. The three are new, with some > > > startup data. The other 5 we want to leave as is on the server. > > > > Ed > > > > On Jan 25, 3:14 pm, Matt Buck <[email protected]> wrote: > > > > heroku db:push [<database_url>] > > > > > So, if you're using a local mysql database that you want to replicate up > > > to > > > > your server, it would look (something) like this: > > > > > mysql://user:passw...@localhost/development?encoding=utf8 > > > > > HTH, > > > > Matt Buck > > > > > On Fri, Jan 22, 2010 at 9:40 AM, Ed Jones <[email protected]> wrote: > > > > > How do I move some new tables up to the server? That is, leave the db > > > > > tables which exist on Heroku as is, but copy my local data for three > > > > > newly created tables? ( I already did db:migrate). > > > > > > Thanks > > > > > > -- > > > > > 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]<heroku%[email protected]> > > > <heroku%[email protected]<heroku%[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]<heroku%[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.
