Recently I had to migrate a production database from SQLite1 to MySQL for a Symfony application using Doctrine. I assumed this would be as easy as running a single command, but it turned out to be slightly more involved. Not hard by any means, but I did have to figure out a few things and piece together a few pieces of the puzzle. The first few searches lead me to SQLite's .dump command2, which dumps the entire database (including table structure and indices) to a text file. This approach req...
