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

You have to make these replacements:

• 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"

Now you can simply import your new MySQL dump.