How to transfer my data from my rails application from mySql to SQLite?
Is it possible?
Great question!
In the past, I had to migrate Gb databases from SQlite to MySQL in PostgreSQl and vice versa. I tried many utilities, scripts and tools, but the only way I found a successful database migration was to export data to a schema without a database, and then import the data.
This plugin saved my life thousands of times: yaml_db .
" ", - , DB, mysql db dbb sqlite, sqlite.
" ", .
, , , mySQL, . , mySql - ( , , - phpmyAdmin), , ( , ), - :
sqlite3 <database name> ".import <export file name>"
In addition, there is a script to automate this on this page on the sqlite website so you can see if this really works.