MobileRead Forums - View Single Post

kovidgoyal · 10-04-2009, 01:15 PM

Ah looks like your database file has gotten corrupted somehow. There are ways you can try to restore it. Install the sqlite command line tool from

http://www.sqlite.org/sqlite-3_6_18.zip

then run the command

sqlite3 metadata.db > dump.sql

(metadata.db is the sqlite calibre database it will be in the calibre library folder)

This command (if it succeeds) will create a file called dump.sql

Run

ren metadata.db metadata.db.orig && sqlite3 metadata.db < dump.sql

10-04-2009, 01:15 PM	#4
kovidgoyal creator of calibre Posts: 45,433 Karma: 27757438 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Ah looks like your database file has gotten corrupted somehow. There are ways you can try to restore it. Install the sqlite command line tool from http://www.sqlite.org/sqlite-3_6_18.zip then run the command sqlite3 metadata.db > dump.sql (metadata.db is the sqlite calibre database it will be in the calibre library folder) This command (if it succeeds) will create a file called dump.sql Run ren metadata.db metadata.db.orig && sqlite3 metadata.db < dump.sql