Thanks for the suggestion and the link.

On Fri, Dec 2, 2011 at 11:49 PM, Roger Binns <rog...@rogerbinns.com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 02/12/11 06:44, George Eckert wrote:
> > Does anyone know of a "good" way to forfce an error in a database so
> > that PRAGMA integrity_check would produce an error?
>
> Truncating the database a bit after a vacuum will definitely do it, and it
> will likely open correctly and maybe even do some queries.  You can
> scribble all over the first few pages to make it an invalid database.
>
> If you look at the file format you can see how to do specific corruptions
> such as the free list:
>
>  http://www.sqlite.org/fileformat2.html
>
> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk7ZqlQACgkQmOOfHg372QQIYwCg4GFPTPkEBAJ4Kb9elXnFpVW9
> BuYAn1dl9jnvKycd/GkufIG6s8aMqnTT
> =PHlw
> -----END PGP SIGNATURE-----
> _______________________________________________
> 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

Reply via email to