Ruby on Rails MySQL to SQLite export/dump

Question

Is it possible to export or dump a MySQL database that can be easily imported into SQLite? The export would be initiated by the logged in user of the application so a command line script probably wouldn't be feasible here. Any suggestions or gems that can achieve this?

Thanks!

Certainly it's possible, I don't specifically how, but but you should be able to find the answer you're looking for at seanbehan.com/… give that a read and you can setup a script in your lib directory and call it from a controller action — Noz
– Noz, Commented Oct 22, 2012 at 20:08

Sean Xiao · Accepted Answer · 2012-10-22 20:18:13Z

1

Try yaml_db gem.

With this gem you can dump the data from MySQL and load to SQLite.

answered Oct 22, 2012 at 20:18

Sean Xiao

6162 gold badges12 silver badges21 bronze badges

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

2 Comments

Noz Over a year ago

OP doesn't want to have to do it in the command line he wants to do it during runtime.

MrTheWalrus Over a year ago

Well, Rails is perfectly capable of executing arbitrary command line instructions. (A few ways are documented here: rubyquicktips.com/post/5862861056/execute-shell-commands). Not saying there isn't a better way, but it should work.

Collectives™ on Stack Overflow

Ruby on Rails MySQL to SQLite export/dump

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related