PRS-T1 How to delete database-entries ?

Schussel · 09-01-2012, 06:01 PM

During the Sync-Process between PC-Software & Reader there are a couple of databases in the \SDCard\Sony_Reader\Database Directory which were not synchronized correctly. That happens, how far I can see especially, if files from the reader are deleted directly from the sdcard, not using the surface-menu.

That happened to me with some pictures which I deleted from the directly from the sdcard, so I have an image.db-file with pictures in, which I can see the from the PC-Software in the pictures-tab but cant do anything with it.

Unfortunately there is no function somewhere to delete the old unused entries. I found no way to delete the 'dead' entrys, neither from the PC-Software nor from the Reader.

So, if there is a way to empty all of the databases or to get a set of clean original databases for audios, books, images & notepads that will help to set up my synchronsing from a defined new starting-point.

Thanks in advance
Schussel

PS: I have a rooted Reader & I use the PC-Software v1.1.05

pholy · 09-05-2012, 04:02 PM

You could always do a factory reset... sort of like an atomic bomb, of course. Or you can find and install a SQLite database browser and delete the entries in each table that refer to the books you deleted. None of the tables are terribly complicated, but there are lots of them.
The joys of readers with databases; Kobo suffers also. My BeBooks only use the filesystem as their database

Kolenka · 09-05-2012, 06:53 PM

After disconnecting from the PC, the Reader should check through the file system and update the DB with information from the filesystem.

For the Sony Readers, the SQLite DB acts like the older XML caches. Useful for speeding up the device, but the filesystem is the final word. However, the trigger for a refresh is usually disconnecting the USB cable.

How did you delete these files? When I delete them directly from a PC it behaves correctly and removes them. Did you delete them from the device itself using a file explorer on the Reader?

Schussel · 09-08-2012, 11:39 AM

I guess my problem is cleared.

You're right, the reader actualizes the database entries by itself. And as a result I get a 18-MByte-File again every time. I have had the hope to reduce the size of that file, but it seems, it will stay somewhere around that size.

Thanks anyway for your answers.

Regards
Schussel

09-01-2012, 06:01 PM	#1
Schussel Member Posts: 14 Karma: 10 Join Date: Jun 2012 Device: Sony PRS-T1	How to delete database-entries ? During the Sync-Process between PC-Software & Reader there are a couple of databases in the \SDCard\Sony_Reader\Database Directory which were not synchronized correctly. That happens, how far I can see especially, if files from the reader are deleted directly from the sdcard, not using the surface-menu. That happened to me with some pictures which I deleted from the directly from the sdcard, so I have an image.db-file with pictures in, which I can see the from the PC-Software in the pictures-tab but cant do anything with it. Unfortunately there is no function somewhere to delete the old unused entries. I found no way to delete the 'dead' entrys, neither from the PC-Software nor from the Reader. So, if there is a way to empty all of the databases or to get a set of clean original databases for audios, books, images & notepads that will help to set up my synchronsing from a defined new starting-point. Thanks in advance Schussel PS: I have a rooted Reader & I use the PC-Software v1.1.05 Last edited by Schussel; 09-01-2012 at 06:36 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
BUG: No ability to re-scan or delete entries in the library	D4N14L	enTourage Archive	2	04-08-2010 09:03 AM
Manually add/delete ebooks to a database	sariel2413	Calibre	3	03-18-2010 04:45 PM
just delete books from database not from disk	droople	Calibre	5	01-31-2010 03:43 AM
Delete files in PC not equal to delete in Sony reader 505	sheilalayoli	Sony Reader	5	07-12-2009 03:13 PM
How to delete database and start fresh?	fshapps	Calibre	1	02-08-2009 06:28 PM

09-05-2012, 04:02 PM	#2
pholy Booklegger Posts: 1,801 Karma: 7999816 Join Date: Jun 2009 Location: Toronto, Ontario, Canada Device: BeBook(1 & 2010), PEZ, PRS-505, Kobo BT, PRS-T1, Playbook, Kobo Touch	You could always do a factory reset... sort of like an atomic bomb, of course. Or you can find and install a SQLite database browser and delete the entries in each table that refer to the books you deleted. None of the tables are terribly complicated, but there are lots of them. The joys of readers with databases; Kobo suffers also. My BeBooks only use the filesystem as their database

09-05-2012, 06:53 PM	#3
Kolenka <Insert Wit Here> Posts: 1,017 Karma: 1275899 Join Date: Jan 2008 Location: Puget Sound Device: Kindle Oasis, Kobo Forma	After disconnecting from the PC, the Reader should check through the file system and update the DB with information from the filesystem. For the Sony Readers, the SQLite DB acts like the older XML caches. Useful for speeding up the device, but the filesystem is the final word. However, the trigger for a refresh is usually disconnecting the USB cable. How did you delete these files? When I delete them directly from a PC it behaves correctly and removes them. Did you delete them from the device itself using a file explorer on the Reader?

09-08-2012, 11:39 AM	#4
Schussel Member Posts: 14 Karma: 10 Join Date: Jun 2012 Device: Sony PRS-T1	I guess my problem is cleared. You're right, the reader actualizes the database entries by itself. And as a result I get a 18-MByte-File again every time. I have had the hope to reduce the size of that file, but it seems, it will stay somewhere around that size. Thanks anyway for your answers. Regards Schussel

Advert