On Wed, Mar 3, 2010 at 8:57 AM, Collin Capano <cdcap...@physics.syr.edu>wrote:
> The databases in question don't seem to be > corrupt; I can open them on the command line and in python programs > (using pysqlite) and can read triggers from them just fine. It's just > when I try to vacuum and create temp tables that I run into trouble. > > Did you try to perform PRAGMA integrity_check; on theses bases? At least you'll be sure sqlite reads all the necessary data and considers it correct. I don't know what will it take for 55G database, maybe hour maybe a full night, but if you have enough time, I'd do this before anything else Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users