Here’s a short guide on how to convert between sqlite2 to sqlite3 database file:
sqlite2 /path/to/mysqlite2.db .dump > backupfile sqlite3 /path/to/mynewsqlite3.db < backupfile
Using the same method, you can convert sqlite3 db to sqlite2 db too!
p/s: Why you need to convert? because embedded device (read: iPhone and Android) only supports sqlite3 database, while PHP 5 by default supports sqlite2 database.
Thus, this method provide a convenient way to convert between the two different version of sqlite db format.