Re: [sqlite] undelete records?
Even if the meta data is gone - is there a way to access these deleted items and let a secondary program deal with the contents? Thanks, Art drh wrote: > > Kimball Larsen <[EMAIL PROTECTED]> wrote: >> I have an sqlite 2.1 format database file with records in it that >> have been marked deleted (I believe the term for this is that their >> pages are on the freelist) >> Is there any simple way to get these records back? Or are they gone >> forever? >> Autovacuum was not on, and with a hex editor I can see portions of >> the records we need to recover. >> > > Important meta information has been lost. Your records are gone > forever. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > -- View this message in context: http://www.nabble.com/undelete-records--tf840751.html#a6494005 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] undelete records?
Kimball Larsen <[EMAIL PROTECTED]> wrote: > I have an sqlite 2.1 format database file with records in it that > have been marked deleted (I believe the term for this is that their > pages are on the freelist) > Is there any simple way to get these records back? Or are they gone > forever? > Autovacuum was not on, and with a hex editor I can see portions of > the records we need to recover. > Important meta information has been lost. Your records are gone forever. -- D. Richard Hipp <[EMAIL PROTECTED]>
[sqlite] undelete records?
I have an sqlite 2.1 format database file with records in it that have been marked deleted (I believe the term for this is that their pages are on the freelist) Is there any simple way to get these records back? Or are they gone forever? Autovacuum was not on, and with a hex editor I can see portions of the records we need to recover. Thanks! -- Kimball