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

[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