On Tue, 12 Jan 2010 14:27:16 -0800 (PST), puk
<dark-free...@web.de> 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_check; prints out that the db is malformed.
>I know that the db and all the information are there.
>What can i do/try to make the db work again.
>
>The SD-card is formatted with FAT-Filesystem.
>I tried to recover the file with windows and linux-applications.
>Is there a way to get the formatting sorted so sqlite is able to use it
>again - it's just an idea that i have.
>
>Thank you all
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
Hope this helps
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
