Mobileread
Deleting preloaded books from Kobo
#1  srid 05-01-2010, 09:02 PM
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).
Reply 

#2  JCSullivan 05-03-2010, 03:36 AM
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.
Reply 

#3  midtoad 05-04-2010, 04:08 PM
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.
Reply 

#4  JCSullivan 05-05-2010, 03:08 PM
Quote midtoad
Modifying databases through command-line instructions is not a newbie skill.
That's what I'm doing now. What I did was before the idea of writing the app. came-up.
Reply 

#5  corona 05-05-2010, 08:11 PM
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.
Reply 

#6  HarryH 05-10-2010, 12:01 AM
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
Reply 

#7  terifili 05-16-2010, 05:42 PM
Can you choose which books you specifically want to delete from the free ones?
Reply 

#8  srid 05-16-2010, 05:48 PM
Quote terifili
Can you choose which books you specifically want to delete from the free ones?
Yes. You need to know SQL for that.
Reply 

#9  corona 05-16-2010, 09:29 PM
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!
Reply 

#10  Stinger 05-16-2010, 09:50 PM
The database didn't get smaller because you didn't actually delete the books, just the indexs
Reply 

  Next »  Last »  (1/3)
Today's Posts | Search this Thread | Login | Register