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
::
sqlite3 /path/to/SSD/databasefile .dump tblN >db_tblN.sql
That is what i get after doing (sqlite3 memos.db .dump > db.sql)
db.sql contains the following three lines:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
To get tha names of the tables i did the following:
sqlite> SELECT name FROM sqlite_master
...> WHERE type='table'
...> ORDER BY name;
and i get:
Error: database disk image is malformed
--
View this message in context:
http://old.nabble.com/after-recover-lost-data-still-lost-tp27135953p27143298.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
