05-01-2010, 08:02 PM | #1 |
Member
Posts: 20
Karma: 10
Join Date: May 2010
Location: North Vancouver, BC
Device: Kindle 2
|
Deleting preloaded books from Kobo
Kobo ships with about 100 preloaded books, which you can also download for free from sites like feedbooks.com. As there is no way to organize your books, navigating to your favourite book can be cumbersome.
I chose to delete the preloaded books and upload the handful of books that can be easily accessed. On Mac OS X, I used the following command to delete the preloaded books. sqlite3 /Volumes/KOBOeReader/.kobo/KoboReader.sqlite "delete from content where ___userid != 'adobe_user'" Make sure that you make a backup of the "KoboReader.sqlite" file before modifying it. Once you are done, eject the Kobo and "reset" it (see the pin hole at the back). Last edited by srid; 05-01-2010 at 08:07 PM. Reason: you must reset it |
05-03-2010, 02:36 AM | #2 |
Chief Inspector Gamache
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
|
Yes, DO make sure you have a backup of the sqlite file.
I deleted the file and reset the kobo and managed to finally get rid of the default books however, ALL my books remained there BUT I had no navigation to get to them. |
Advert | |
|
05-04-2010, 03:08 PM | #3 |
Junior Member
Posts: 8
Karma: 12
Join Date: Dec 2002
|
Modifying databases through command-line instructions is not a newbie skill. Why not wait for completion of the app that is being worked on just for this purpose? See the forum topic on sqlite database.
|
05-05-2010, 02:08 PM | #4 |
Chief Inspector Gamache
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
|
|
05-05-2010, 07:11 PM | #5 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
You can also go into the database and take out specific books. I used SQLite Expert (free) personal edition (and no this isn't a plug!). Anyway, it worked very nicely.
|
Advert | |
|
05-09-2010, 11:01 PM | #6 |
Enthusiast
Posts: 36
Karma: 10
Join Date: May 2010
Location: Nova Scotia
Device: Kobo Version 1 firmware v 1.8.3
|
hello
Mac OS X , below as posted sqlite3 /Volumes/KOBOeReader/.kobo/KoboReader.sqlite "delete from content where ___userid != 'adobe_user'" I wounder if this command can be used in a Linux OS with a modified path ?? This would delete any purchased books , Are they still available on the kobobooks site???? to resyc ??? Corona's post using windows sqlite editor , is there a similar Linux program for sqlite DB's Harry |
05-16-2010, 04:42 PM | #7 |
Enthusiast
Posts: 49
Karma: 106
Join Date: May 2010
Device: Kobo
|
Can you choose which books you specifically want to delete from the free ones?
|
05-16-2010, 04:48 PM | #8 |
Member
Posts: 20
Karma: 10
Join Date: May 2010
Location: North Vancouver, BC
Device: Kindle 2
|
|
05-16-2010, 08:29 PM | #9 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
Crude but (apparently) effective...
I got rid of the 100 books, and everything else. (The "everything else" was books I purchased and checked out of the library; I put those back in at the end.)
So far anyway my Kobo doesn't seem like a brick. But really, I don't know what will happen to you and your Kobo if you try this. The first thing I did was go to ADE and take everything I could off of the Kobo. Then I backed up the Kobo's file system by copying it to someplace on my hard drive. I don't actually know if this would be effective if needed. Maybe it wouldn't work to just copy it all back to the Kobo. I didn't have to, so I don't know. I just copied everything in the Kobo -- using Windows Explorer -- onto the hard drive. Everything else below I did right on the Kobo, with Windows Explorer and a Firefox add-on called "SQLite Manager." The Kobo came up on my computer as drive G. I had some PDFs in the G:\ directory. I deleted those. I opened the G:\books file with Notepad and deleted everything in the file. It's just a text file; I think this was some values of the variable "contentID" in the database content table -- maybe for the freebee books? Anyway. I saved the now-empty file. I went to G:\.kobo\images folder and deleted all the files (this is the cover images). I used the SQLite Manager to open the database and delete all of the entries (but not the table structure!) of the tables: "content", "shortcover_page", and "volume_shortcovers". This took a few minutes, definitely. (I did it with simple SQLite statements; line-by-line manually would take forever.) In the "user" table I deleted the user "Nickel Bundle" (which left just me as a user). "Nickel Bundle" appears at various places, and I assume it pertains to the 100 freebees. I didn't fool around with the "DbVersion" table. Added step: compact the database ("vacuum" command in SQLite parlance). This takes a while. I closed the database, ejected and unplugged the Kobo. Seemed okay. I plugged it back in again and added the books I purchased from Kobo store, and checked-out books in the ADE. As usual, I had to go into the Kobo and move the checked-out PDF books up to the root (G:\) directory so they would appear at all (as documents, not books). Interesting facts: -it seems to have worked just fine. -the G:\books file remains empty, but that doesn't seem to have any effect. -at some point while I was fooling around with the db (I didn't notice it when it happened) the red battery-ok light came on. I haven't seen it for ten days! Last edited by corona; 05-16-2010 at 09:29 PM. Reason: added compacting step |
05-16-2010, 08:50 PM | #10 |
Asha'man
Posts: 335
Karma: 844
Join Date: May 2010
Location: Canada
Device: Kobo
|
The database didn't get smaller because you didn't actually delete the books, just the indexs
|
05-16-2010, 08:59 PM | #11 | |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
Quote:
Hmm; yeah, okay. That's kind of embarrassing. But at least I don't have to look at them anymore (and the red light came on). It would be nice to know how to actually expunge the data itself. Last edited by corona; 05-16-2010 at 09:05 PM. |
|
05-16-2010, 09:13 PM | #12 | |
Asha'man
Posts: 335
Karma: 844
Join Date: May 2010
Location: Canada
Device: Kobo
|
you're correct, the actual page data is in the shortcover_page table, in the 'FormattedPage'.
This should be helpful to you: http://wiki.durbn.net/koboko/index.php/DBSchemaV2 EDIT: OH! I missed that you deleted cleared the shortcover_page table in your original post. In that case you DID delete the book data. This is the reason the dbase hasn't shrunk: Quote:
Last edited by Stinger; 05-16-2010 at 09:24 PM. |
|
05-16-2010, 09:25 PM | #13 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
|
05-17-2010, 01:49 PM | #14 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Location: Netherlands
Device: Sony PRS-505, PRS-T1
|
Is it also possible to get rid of the preloaded 100 books by just simply going in to the menu on the Kobo and reset it to factory default? I would imagine this would get rid of anything other than the OS, so no books, no settings etc.
(Still waiting for mine to ship to Holland, so haven't been able to try it, just wondering) |
05-17-2010, 02:20 PM | #15 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Deleting books from kobo ereader | karenaH | Kobo Reader | 9 | 12-16-2012 02:17 PM |
New Calibre Kobo Driver allows deleting of Kobo Free books | timlegge | Kobo Reader | 46 | 08-27-2011 10:16 PM |
Covers of the preloaded books disappeared - Help please! | georges0701 | Kobo Reader | 6 | 06-20-2010 05:57 PM |
Preloaded books for SONY PRS600 | NYUDeb | Sony Reader | 2 | 12-28-2009 06:49 AM |
PRS-600 Preloaded Books | NYUDeb | Sony Reader | 1 | 12-25-2009 12:50 PM |