Today I (re)learnt the one about counting the ways of skinning cats. We use MySQL for our data, but for unit tests it's just easier to use SQLite. Except for converting the SQL from one to the other. No problem you say: SQL fairy to the rescue. Not so fast I reply: the fairy does not understand all of the SQL we use. After much banging of head against this particular brick wall, a colleague (thx Robbie) pointed out that MySQL can parse all of the SQL (as that's the DB it has to work against. Just do that and then mysqldump the results. Job done.
