[LRUG] Migrating SQLlite to MySQL

[Tom Stuart]

On 16 Nov 2009, at 12:52, Glenn @ Ruby Pond Ltd wrote:
> I've got a cap/rake task that pulls down the data and loads it
> Not great if you've got loads of data on production

Yeah, in particular it's cripplingly slow to export/import large amounts of data with YAML. In that case I'd suggest using the SQLite console's .dump command (see "Converting an entire database to an ASCII text file" on http://www.sqlite.org/sqlite.html) and piping the resulting vanilla SQL file into MySQL to recreate the data.

Cheers,
-Tom