2

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?)

jonepatr
  • 7,769
  • 7
  • 30
  • 53
  • 2
    "Silently" dropping database and importing in from scratch isn't an option (can be fast and easy when using `mysqldump | mysql`)? – Vyktor Feb 03 '12 at 11:41

1 Answers1

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:

Community
  • 1
  • 1
iblue
  • 29,609
  • 19
  • 89
  • 128