Written 2016-11-19

Tags:sqlite mysql 

Ever downloaded a fresh, tasty database dump, only to be frustrated by the need to setup an entire mysql database backend just to read it, even though you have a perfectly good SQL engine available from SQLite? Look no further! mysql2sqlite is a simple awk program that will transparently convert mysql syntax into sqlite syntax. Mostly, this consists of dropping a few unsupported keywords, and it is not without bugs - mysql foreign key relationships will not quite make it into the sqlite database. But for simply loading the data into a sane, searchable format, mysql2sqlite will get you a perfectly functional database quickly and easily.