Hi all, I have the following database where one of the entities in the database is corrupted (dumping doesn't retrieve any data). Is there any way at all to fix this database file or is it gone for good?
Harrys-Retina-MacBook-Pro:wetransfer-3bb6e0 Harry$ *ls* ProjectDataBase.xcdatamodeld Harrys-Retina-MacBook-Pro:wetransfer-3bb6e0 Harry$ *sqlite3 ProjectDataBase.xcdatamodeld '.dump ZIMAGE'* PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE ZIMAGE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCHANGED INTEGER, ZDBID INTEGER, ZDISPLAYORDER INTEGER, ZPARENTPROJECT INTEGER, ZDATE TIMESTAMP, ZANNOTATIONPATH VARCHAR, ZCOMMENT VARCHAR, ZIMAGEPATH VARCHAR, ZORDER VARCHAR, ZOWNER VARCHAR, ZTHUMBNAILPATH VARCHAR, ZTITLE VARCHAR, ZDRAWNSTROKES BLOB, ZIMAGE BLOB, ZTHUMBNAIL BLOB ); /**** ERROR: (11) database disk image is malformed *****/ /**** ERROR: (11) database disk image is malformed *****/ CREATE INDEX ZIMAGE_ZPARENTPROJECT_INDEX ON ZIMAGE (ZPARENTPROJECT); ROLLBACK; -- due to errors -- ______________________ Harry Thompson Managing Director Veam Studios - http://www.veamstudios.com Mobile: +44 (0)7951 563 942 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
