MobileRead Forums - View Single Post - Sony PRS-T1 in Calibre

Kolenka · 10-18-2011, 02:56 AM

Are you actually on a Mac or Linux machine? If that is the case you can pretty much copy/paste this into the Terminal:

Code:

echo ".dump" | sqlite3 /Volumes/READER/Sony_Reader/database/books.db | sqlite3 ~/Desktop/books.db
cp ~/Desktop/books.db /Volumes/READER/Sony_Reader/database/books.db

That will recreate the DB and put it back onto the Reader (assuming you have no SD card as well). I'm not familiar with SQLite on Windows to know how to repair it through cmd.exe.

10-18-2011, 02:56 AM	#251
Kolenka <Insert Wit Here> Posts: 1,017 Karma: 1275899 Join Date: Jan 2008 Location: Puget Sound Device: Kindle Oasis, Kobo Forma	Are you actually on a Mac or Linux machine? If that is the case you can pretty much copy/paste this into the Terminal: Code: echo ".dump" \| sqlite3 /Volumes/READER/Sony_Reader/database/books.db \| sqlite3 ~/Desktop/books.db cp ~/Desktop/books.db /Volumes/READER/Sony_Reader/database/books.db That will recreate the DB and put it back onto the Reader (assuming you have no SD card as well). I'm not familiar with SQLite on Windows to know how to repair it through cmd.exe.