← back to overview

HowTo: Migrate a database dump from SQLite to MySQL

Grab the (sqlite) sql dump an fire up your editor:

sqlite3 db/development.sqlite .dump .quit > dump.sql

• replace all double-quotes (") with grave accents (´) (in vim just type :%s/"/´/)

• replace "autoincrement" with "auto_increment"

• remove "BEGIN TRANSACTION;" from the beginnig of the dump

• remove "COMMIT;" from the end of the dump

• remove all lines containing "sqlite_sequence"

You're done. Just import your new MySQL dump.