Re: [sqlite] undelete records?

[azerger]

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?

[drh]

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?

[Kimball Larsen]

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