What is the best(easiest...) way to get all the data from a production DB, so I can throw it onto my development DB, and use it locally? ~Jeremy -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
> What is the best(easiest...) way to get all the data from a production > DB, so I can throw it onto my development DB, and use it locally?If it''s the same database type then just dump it out of production, copy the dump file to your development machine and import it. If it''s not the same database type, you might look into taps... http://rubygems.org/gems/taps -philip -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Philip Hallstrom wrote in post #962498:>> What is the best(easiest...) way to get all the data from a production >> DB, so I can throw it onto my development DB, and use it locally? > > If it''s the same database type then just dump it out of production, copy > the dump file to your development machine and import it. > > If it''s not the same database type, you might look into taps... > http://rubygems.org/gems/taps > > -philipSweet! Thanks for the link. That''s pretty awesome. Ok, so, I''ve never actually done a data dump or import before. Both my production, and development databases are using MySQL (the production being on a server). Is there a rake task that creates a SQL file? I know there''s rake db:structure:dump, but I''m not sure if this actually will throw all the data into the SQL file, or just the overall structure of the DB like the schema. I also need to make sure that whatever command this is, doesn''t just drop my production DB (Don''t need a "github incident") lol. Thanks for the help, ~Jeremy -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
>>> What is the best(easiest...) way to get all the data from a production >>> DB, so I can throw it onto my development DB, and use it locally? >> >> If it''s the same database type then just dump it out of production, copy >> the dump file to your development machine and import it. >> >> If it''s not the same database type, you might look into taps... >> http://rubygems.org/gems/taps >> >> -philip > > Sweet! Thanks for the link. That''s pretty awesome. > > Ok, so, I''ve never actually done a data dump or import before. Both my > production, and development databases are using MySQL (the production > being on a server). Is there a rake task that creates a SQL file? I know > there''s rake db:structure:dump, but I''m not sure if this actually will > throw all the data into the SQL file, or just the overall structure of > the DB like the schema.Just the structure...> I also need to make sure that whatever command > this is, doesn''t just drop my production DB (Don''t need a "github > incident") lol.Read up on mysqldump. -philip -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
> Read up on mysqldump. > > -philipAwesome, that would be what I''m looking for. Thanks man! -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Here is the syntax for export and import: http://bparanj.blogspot.com/2007/06/how-to-export-data-from-one-database.html On Thu, Nov 18, 2010 at 9:31 PM, Jeremy Woertink <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote:> > Read up on mysqldump. > > > > -philip > > Awesome, that would be what I''m looking for. Thanks man! > > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- Cheers, Bala RoR Developer Now Available for Hire -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.