Sqlite database replacement instructions

[pholy]

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.

Note: Version 1.8 is only used in the Original Kobo.

As requested by Sameer H :

NOTE: The Links below are for the db used with software version 1.4.

To put a fresh db on your eReader.

Fetch this zip file

http://download.kobobooks.com/deskto...-fresh-1-4.zip

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)

XP: My Computer > Tools menu > Folder Options > View Tab > Advanced Settings > Hidden Files and Folders > Show hidden files and folders.
OK all the way out.

Vista and Windows 7: Start > Control Panel > Folder Options > View Tab > Click Show Hidden files and folders > OK

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)

[sabredog]

These instructions should be pinned

[corona]

I thought we had pretty much come to the conclusion that you could just nuke it, and it would get automatically rebuilt when next you synchronized your reader.

[3d0g]

Originally Posted by corona

I thought we had pretty much come to the conclusion that you could just nuke it, and it would get automatically rebuilt when next you synchronized your reader.

It does, but you loose 100 books.

[SameerH]

Originally Posted by 3d0g

It does, but you loose 100 books.

And they're pretty good books

[livre]

Thank you so much, you saved my Kobo :-)

[auriel]

Thanks! I'm gonna try this. I restored my Kobo to factory settings to clear the internal memory and I lost one of the 100 preloaded books.

[p_a_smith]

The instructions worked like a charm on my corrupted database. I like my Kobo even more knowing I can restore the original database!

[cjob68]

I am now getting "We are unable to update your devices database. Syncing cannot be completed" after doing this. Any ideas ?

[pholy]

What software versions to you have on your Kobo and PC? The refresh db is definitely for 1.4.

Unfortunately, that's my only idea

[PeterT]

Should this be updated to include new instructions for Kobo Wireless (especially in light of a new database schema)?

[JCKobo]

Originally Posted by PeterT

Should this be updated to include new instructions for Kobo Wireless (especially in light of a new database schema)?

We've greatly improved the factory reset process on the Kobo Wireless Reader. You should always be able to reset your database by just doing a Factory Reset.

To do this:
1) Press Menu
2) Select settings
3) Select advanced
4) Select factory reset
5) Accept

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

[PeterT]

That is fantastic news I see I will have to get me one soon...

[jean_wat]

Having owned my new Kobo Wireless for 3 days, my database was completely screwed.

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?

Originally Posted by JCKobo

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

[3d0g]

Originally Posted by jean_wat

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

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

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?

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.