Les Partages de Memiks
Tag cloud
Picture wall
Daily
RSS Feed
  • RSS Feed
  • Daily Feed
  • Weekly Feed
  • Monthly Feed
Filters

Links per page

  • 20 links
  • 50 links
  • 100 links

Filters

Untagged links
Sergei Dorogin's technical blog: SQLiteException "database disk image is malformed" http://techblog.dorogin.com/2011/05/sqliteexception-database-disk-image-is.html
Wed Jun 15 17:14:23 2016 archive.org
QRCode

Réparer une base sqlite corrompue
Trés utile ;)

Via : http://www.librement-votre.fr/shaarli/?D3lHhg

So, something's broken.
I executed a query like "select * from {table}" for each table in the database and all of them was executed successfully except one. This one caused the exactly same error I saw before -"database disk image is malformed". But in spite of error I got data from this table.

So if I can read data then I can recreate my database.
I started searching for a way how to dump data from the database into a SQL-script with INSERTs. This post helped me a lot.
I needed to download SQLite shell. This tool allows to export data in many forms including INSERTs.
I run "sqlite3.exe storage.data" where "storage.data" is my corrupted database file.
The following script exports all content (as INSERTs) with schema into "dump_all.sql" file:

sqlite> .mode insert
sqlite> .output dump_all.sql
sqlite> .dump

Then exit (Ctrl-C, Ctrl-Z or ".exit") and run again: "sqlite3.exe storage.fixed.data", where "storage.fixed.data" is name of non-existing file for my resurrected database.
The following script reads commands from "dump_all.sql" script file and recreates all database.

sqlite> .read dump_all.sql

After this procedure I got a new database file with all content from the corrupted file.

sqlite corrompu repare corrupt
4759 links, including 1673 private
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn