To get the database used for software version 1.8, refer to this post in this thread. The installation instructions are the same as those included here -- except that the kobo-dir-pristine also contains a kepub folder which must be also copied to the .kobo folder.

1. Attach the eReader to the computer
2. Ensure that it is detected as mass storage

FOR A MAC:
1. Open mass storage device in Finder
2 . Select the "GO" option from the top menu
3. Select Go to folder
4. Type in .kobo
5. .kobo folder will open
6. Delete the images folder
7. Delete the KobReader.sqlite file (this is the database file)
8. From a new Finder window, browse to where the downloaded zip file is.
9. Unzip the file, it will unzip a folder called kobo-dir-pristine
10. Open kobo-dir-pristine, copy the images folder and the KoboReader.sqlite file over to the .kobo folder on the mass storage.
11. Eject the eReader
12. Restart the eReader (power off, and then power back on)

ON A PC
1. Open mass storage device in Finder
2. Ensure hidden folders are visible (different for different Windows versions)

3. Open .kobo folder on the mass storage
6. Delete the images folder
7. Delete the KobReader.sqlite file (this is the database file)
8. Unzip the downloaded file to an accessible folder, it will unzip to a folder called kobo-dir-pristine.
9. Open kobo-dir-pristine, copy the images folder and the KoboReader.sqlite file over to the .kobo folder on the mass storage.
10. Eject the eReader
11. Restart the eReader (power off, and then power back on)

Last edited by pholy; 12-17-2010 at 09:37 AM.
Reason: Also copy the kepub folder

Resetting factory settings wipes out everything, including date, time, and wireless passwords. I have a fairly strong (and long) password for my wireless router. Took FOREVER to input using the Kobo originally. If I have to do this every week or so then the wireless will effectively be useless.

It would be much easier to just replace the sqllite db. Seriously Kobo, please give us that option!

Or even better, fix the DB so that it doesn't get corrupted...

Seriously, how did that happen so easily in 2 days?

Quote:

Originally Posted by JCKobo

You should have a Kobo Wireless Reader just like it came from the factory.

Good question since I've had my original kobo since release day and have had absolutely zero issues with it. Actually, I'd expect that as SQLite is ACID compliant and very rugged - it's specifically designed for applications like this. Perhaps your issues aren't DB related?

Quote:

SQLite is Transactional

A transactional database is one in which all changes and queries appear to be Atomic, Consistent, Isolated, and Durable (ACID). SQLite implements serializable transactions that are atomic, consistent, isolated, and durable, even if the transaction is interrupted by a program crash, an operating system crash, or a power failure to the computer.

We here restate and amplify the previous sentence for emphasis: All changes within a single transaction in SQLite either occur completely or not at all, even if the act of writing the change out to the disk is interrupted by

* a program crash,
* an operating system crash, or
* a power failure.

The claim of the previous paragraph is extensively checked in the SQLite regression test suite using a special test harness that simulates the effects on a database file of operating system crashes and power failures.