MySQL to SQLite converter

Question

I have two tables

regions(id, name)
countries(id, name, region_id)

which is in MySQL format and i want to convert it into SQLite database. I have tried a few softwares but i am not able to get it to convert.

Is there any easy wat to convert them considering its a fairly simple tables.

I had a look at the following links

http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

http://dbconvert.com/convert-sqlite-to-mysql-pro.php

Either the software is paid or i am not able to get them to work.

Answer 1

See this Gist. It works on Linux.