Populate development database with production database values

Question

I'm wondering how I could populate my development SQLite database with my values from the production server (MySQL) in an easy way. Is there a nice "railsy" way for doing this? (capistrano or something like that maybe?)

"Silently" dropping database and importing in from scratch isn't an option (can be fast and easy when using mysqldump | mysql)? — Vyktor
– Vyktor, Commented Feb 3, 2012 at 11:41

Community · Accepted Answer · 2017-05-23 12:27:29Z

2

You can use the following script to convert mysqldump format to sqlite3: script to convert mysql dump sql file into format that can be imported into sqlite3 db

Then just take a look at the following articles to write your own capistrano tasks:

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Feb 6, 2012 at 14:04

iblue

30.6k20 gold badges93 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Populate development database with production database values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related