MySQL to SQLite converter

converters, mysql, sqlite

Solution

See this Gist. It works on Linux.

Problem

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.

Original source