Daily Archives: 6. May 2015

Migrate SQLite database data dump to MySQL

Grab the (sqlite) sql dump first: sqlite3 db.sqlite .dump .quit > dump.sql Now edit the dump to match the MySQL syntax: replace all double-quotes (“) with grave accents (`) replace “autoincrement” with “auto_increment“ remove “BEGIN TRANSACTION;” from the beginnig of the dump remove “COMMIT;” from the end of the dump […]