Thanks for your reply. I was afraid that may be the case. This is for my application that uses an SQLite database to store 3D data so it would be difficult to find out which set of binary data is corrupt and which is not.
I do encourage my clients to backup the database, it is even stored in the 'My Documents' directory to make it easily accessible. I also created a batch file executable that uses the 'sqlite3.exe' to perform the '.backup' command to create and compress a text version of the database. But I guess that's like trying to herd cats into a dog pound. ;) Regards, ~Kirk. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Artur Reilin Sent: Tuesday, August 03, 2010 7:51 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Repairing a Database. If the database is corrupted, then this is really bad. If you don't have a backup of your file, then it's almost not really possible to repair the database. As far as I know... You could open the database in an editor and try to pick some data, that was left in the database. with best wishes Artur > Hello All, > I am new to SQLite and have run into an issue with a malformed database. > It seems the application using the database was shutdown prematurely > during an update operation and the journal file was never deleted. This > means that on startup the application used the wrong journal file and > corrupted the database. I have seen some information on repairing a > corrupt database and recovering at least some of the data. But I have not > had any luck finding out how to do it. > > Any help would be greatly appreciated. > Kirk_______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
