Re: [sqlite] after recover lost data still lost

2010-01-13 Thread puk
Try: sqlite3 /path/to/SSD/databasefile .dump >db.sql If that doesn't recover enough, do the same for every single table in the database: sqlite3 /path/to/SSD/databasefile .dump tbl1 >db_tbl1.sql sqlite3 /path/to/SSD/databasefile .dump tbl2 >db_tbl2.sql :: s

Re: [sqlite] after recover lost data still lost

2010-01-12 Thread Kees Nuyt
On Tue, 12 Jan 2010 14:27:16 -0800 (PST), puk wrote: > >Hello, >i deleted a db-file from SD-card1. (because i copied it to SD-card2 but >SD-card2 is broken now) >i didn't use SD-card1. >Recovering all files from SD-card1 works. >But the sqlite file is now malformed. >Even the PRAGMA integrity_ch

[sqlite] after recover lost data still lost

2010-01-12 Thread puk
Hello, i deleted a db-file from SD-card1. (because i copied it to SD-card2 but SD-card2 is broken now) i didn't use SD-card1. Recovering all files from SD-card1 works. But the sqlite file is now malformed. Even the PRAGMA integrity_check; prints out that the db is malformed. I know that the db an