Raeds rake task to load real-time database (MySQL) into local development database

Question

For many years, I used the ssh pipe from mysqldumpon the real server to mysqlon my development machine to get a copy of the current data.

ssh -C <server> mysqldump --opt <live_database_name> |mysql <local_dev_database_name>

Where it -Callows ssh compression and --optallows speed and completeness.

Does anyone have an equal elliptical rake task? Ideally, the database names will have config / database.yml

Answer 1

https://gist.github.com/750129

This is not an elegant solution. This is basically a wrapper for your old method, so it is not even compatible with other database drivers.

, SCM lib/tasks, . config/database.yml. live db, , , Rails.

, .

Answer 2

Postgres: https://gist.github.com/748222.

: db:download, db:replace db:restore. db:restore - .

, - Mysql . , .

Answer 3

​​Ruby, seed-fu activerecord-import.

, standalone-migrations. Rake .

!

Answer 4

, rake , capistrano, capistrano , ..

Answer 5

Theoretically, you should create another "instance" in database.yml (for your live server) and place the correct host there (and leave the rest of the username / password, etc.). In your rake task, you upload the database yaml file, read the host, and continue to work with the command line. It could be easily wrapped in a rake.