Re: [sqlite] Data Recovery - Unvacumed DB - OS X Address Book

[Joshua Galvez]

Any help would be appreciated. Even as much as, No, there really is  
no way to do this.

Josh


On Feb 19, 2008, at 7:46 PM, Joshua Galvez wrote:

 Twice recently, on different computers I've had clients lose their  
 OS X Address Book.  Alas, they've not had backups.  I've been able  
 to track down much of their data still remains in an sqlite3  
 data.syncdb file.   But when I access the DB, I find that tables  
 with the actual contacts have been rewritten with only a few  
 records.  But the file size is still ~52mb.  I realize that sqlite  
 being the flat file it is doesn't recover space until you 'vacum'  
 it.   So much of the old information is left floating around in the  
 file.

 How can I recover data from this database?

 Any help or guidance would be much appreciated.

 Josh

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Data Recovery - Unvacumed DB - OS X Address Book

[Joshua Galvez]

Twice recently, on different computers I've had clients lose their OS  
X Address Book.  Alas, they've not had backups.  I've been able to  
track down much of their data still remains in an sqlite3 data.syncdb  
file.   But when I access the DB, I find that tables with the actual  
contacts have been rewritten with only a few records.  But the file  
size is still ~52mb.  I realize that sqlite being the flat file it is  
doesn't recover space until you 'vacum' it.   So much of the old  
information is left floating around in the file.

How can I recover data from this database?

Any help or guidance would be much appreciated.

Josh
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users