(Fri Jan 06 2012 00:00:00 GMT+0200 (Eastern European Standard Time)) I've got a database & website I want to move from using MySQL to using SQLite3. Well, I think I want to use SQLite3. Their document saying what sorts of uses make sense for SQLite3 are directly in line with my website, and I do want to remove some of the load off of my MySQL server so that it can have cycles free for more important purposes.
However I've run into a couple troubles converting the schema so that it fits within SQLite3's limited SQL support. Turns out that it doesn't support some column types and indexes. And that the SQL produced by mysqldump contains some MySQLisms which SQLite3 just doesn't understand.
