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
>
> -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. 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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to