Concatenate two databases together. i.e: $ cat my.db my.db > my_corrupt.db
my_corrupt.db will work fine but the integrity_check pragma will fail. I'm not sure this is exactly what you want though. Dan --- David Costa <[EMAIL PROTECTED]> wrote: > > On Jun 24, 2004, at 12:40 AM, D. Richard Hipp wrote: > > > Snip > > > > > > > > What is a quick and effective way to corrupt a > database and > > reproduce a > > > similar error on pragma integrity check ? > > > > > > > VACUUM the database so that it has no unused > pages. Then change the > > value > > of the first byte of a page. > > I tried but apparently I either get the database > disk image as > malformed or no error at all. > I have attached a simple and small database, if > someone could provide > me with a slightly corrupted version to reproduce a > pragma check error, > I would be very > grateful as I could add this on the examples and > documentation. > > > > > > > > That means that the database is too sick to even > read the SQLITE_MASTER > > table. > > > Thanks a lot for your answer, > Regards > David Costa > > Regards, > David Costa > PEAR- PHP Extensions and Application Repository > Developer > http://pear.php.net/user/gurugeek > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
