Hey, When creating a dump with sqlite .dump, it will not save the user_version.
Firefox is using this user_version to determine the database schema version (or something related). When restoring a dump (but without user_version set properly), firefox will discard all history data. I'm not sure where the issue is fixed best. Firefox developers indicate that they don't consider this their problem. I'm wondering whether sqlite shouldn't dump the user_version as well so that a restored database dump will be indistinguishable from the original database. cheers simon PS: please CC me on replies since I'm not subscribed to the mailing list _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users