Hello,
I am working on an SQLite integrity library for PEAR, the PHP official extensions.
two questions:
a) I am using Pragma integrity check to perform a quality check before the backup
and I just tried to corrupt a database manually by by deleting random lines from the db file.
In some cases the pragma check returnes an error e.g.
"stdClass Object ( [integrity_check] => *** in database main *** List of tree roots: invalid page number 4 Unused space at byte 8 of page 3 ) *** in database main *** List of tree roots: invalid page number 4 Unused space at byte 8 of page 3"
This is fine, but in other database where I did removed random lines, it returns OK
What is a quick and effective way to corrupt a database and reproduce a similar error on pragma integrity check ?
b) in another case of manual corruption the errors comes up at the connection stage and we don't even reach the pragma
error message "database disk image is malformed" on connection.
Thanks in advance for your time and patience,
Regards, David Costa, managing partner at Dotgeek.org 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]
