> I'm curious about this as well...I'd like to take a snapshot of the > database in production and be able to load it in development. What > methods are available with capistrano/rails to handle this?
You can take a dump of your production database and load it directly on your development box if both are using the same database software. postgres: prod$ pg_dump blah > blah.psql prod$ cat blah.psql | ssh [EMAIL PROTECTED] 'cat > ~/backups/sqldumps/ blah-2008-11-08.psql' dev$ dropdb blah_development && createdb blah_development && cat ~/ backups/sqldumps/blah-2008-11-08.psql | psql blah_development A similar process is possible with mysql using mysqldump and mysqladmin. Ben Hoskings --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Deploying Rails" group. To post to this group, send email to rubyonrails-deployment@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-deployment?hl=en -~----------~----~----~----~------~----~------~--~---
