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,738
  • 7
  • 28
  • 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
  • 27,950
  • 18
  • 84
  • 126