lundi 9 février 2015

Backwards compatibility with sqlite DB

In my application I'm using an amalgamated embeded version of SQLite v3.8.4. In the past I had compatibility issues with v3.7 regarding page_size > 32768. Now I'd like to keep backwards compatibility on database files with v3.6.20 (default on RHEL6), but when I try to open my DB file on my RHEL6 machine I see the error:



Error: file is encrypted or is not a database


I can dump the database to an SQL file and then again import it to v3.7. This seems to do the trick to be readable on v3.6.20 but my DB is 3 GB in size and is not feasible for me to wait 2 hours for each dump.


What options can I set on my v3.8 to generate v3.6 compatible databases?


Aucun commentaire:

Enregistrer un commentaire