[sqlite] PRAGMA integrity_check error recovery questions

Does the integrity_check PRAGMA fix any problems that it encounters or does it just report them? Are there anyway of recovering from these errors or is the database unfixable? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] PRAGMA integrity_check error recovery questions

On 17 Jun 2010, at 9:45pm, Jim Terman wrote: > Does the integrity_check PRAGMA fix any problems that it encounters or > does it just report them? Report. > Are there anyway of recovering from these errors or is the database > unfixable? Sometimes VACUUM fixes them. It can conceivably make t

Re: [sqlite] PRAGMA integrity_check error recovery questions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/17/2010 01:50 PM, Simon Slavin wrote: > Sometimes it's best to use the command-line tool to dump the data to a file > of SQL commands, The command line tool needs its code fixing first: http://www.sqlite.org/src/tktview?name=2466653295 In p