Migrate Data and Schema from MySQL to sqlite

Human Dunnil said the following on 02/17/2007 06:38 AM:

I have a client who needs his data on a multimedia CD-ROM. I've used MySQL as a database for his web application. Now, I need to migrate his data on regular basis to sqlite so I can use the new db on the CD-ROM.

What do you guys recommend me to do? Should I write a script which READ data from mysql (using ActiveRecords for example) and INSERT them in the new sqlite? Is there any other solutions?

And I must write a tool or script to run on MS Windows. :frowning:

I was faced with a similar problem. I'd developed on my laptop (32 bit Intel) but the server to be deployed was 64 bit. Tarz'ing up the SQLite database on the one and untarz'ing it on the other meant it was unusable.

So I searched for and found a rakefile that dumped each table to a YAML file. I then used rake to relada them as fixtures.

   rake db:fixtures:load

See Vhttp://snippets.dzone.com/posts/show/3393