How can I migrate my data from my rails app from mySql to SQLite

migration, ruby, ruby-on-rails, sqlite

Solution

Great question!

In the past I had to migrate Gb of databases from SQlite to MySQL to PostgreSQl and viceversa. I tried tons of utilities, scripts and tools but the only way I found to successfully migrate the database was to export the data into a database-free schema, then import the data.

This plugin saved my life thousands of times: yaml_db.

Problem

Original source