![]() |
#1 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 194
Karma: 177180
Join Date: Jun 2009
Location: Mesa, AZ
Device: Sony PRS 505
|
![]()
I got the database is corrupted message in Calibre today. I followed each of the directions...unplugged, replugged did not work. Deleted media.xml, let it regenerate and reconnected. Also went in and checked db integrity. None of these are working.
Suggestions? The books look fine on my Sony and I REALLY don't want to lose all the metadata changes I've been making on these. ![]() |
![]() |
![]() |
![]() |
#2 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Probably slow and cludgy but you could try saving all of your books to a single folder using save to disk and then change your database location under preferences and add them to the fresh database.
If they are just the books on the Sony then maybe just chnging the database location could fix it. Not too sure about that though. Stupid question, but you have rebooted your computer? |
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Banned
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 640
Karma: 4911
Join Date: Jul 2007
Location: Grapevine, TX
Device: iPad4
|
I get this all the time. For me, simply resetting the device works. Following the instructions from Calibre do not work (for me).
The database that Calibre is referring to is on the device, not the PC. |
![]() |
![]() |
![]() |
#4 |
Member
![]() Posts: 19
Karma: 64
Join Date: May 2010
Device: Dell Axim X50v, JetBook Lite
|
Would it be a good idea to have some sort of backup feature? For example, when Calibre closes, it could make a backup of the db, keeping at most x backups?
|
![]() |
![]() |
![]() |
#5 |
Banned
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 640
Karma: 4911
Join Date: Jul 2007
Location: Grapevine, TX
Device: iPad4
|
Again, it is not the Calibre database that is corrupt. The problem is the Sony database (media.xml) on the device. Or, at least Calibre has a problem reading the database. I say that because there are no other ill symptoms using the device.
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 194
Karma: 177180
Join Date: Jun 2009
Location: Mesa, AZ
Device: Sony PRS 505
|
Last night I reset my device as well as deleted the media.xml from the Sony. (and rebooted my computer.)
Edbro is right, it isn't the Calibre dbase that is the problem. For some reason, Calibre stops reading the Sony dbase file. Today, after some sleep and caffeine, this finally sank in. ![]() I think I've fixed it. I shut down Calibre. Used Explorer to delete all the file folders under database>media>books, and also media.xml. Unplugged the Sony from my computer, reset it and turned back on. Then connected it back up, turned on Calibre and it seems to be working fine now. I now have to move the books back over from the Library to the reader, but at least all the metadata changes I've made via Calibre are still there. |
![]() |
![]() |
![]() |
#7 | |
Banned
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 640
Karma: 4911
Join Date: Jul 2007
Location: Grapevine, TX
Device: iPad4
|
Quote:
I don't think you had to delete all the files off the Sony. A simple reset works each time for me. After that, all my files and metadata are still there and it will work again with Calibre. If you do want to delete all the files again, there is a format disk option on the device itself that would be better. That will wipe the memory on the device. |
|
![]() |
![]() |
![]() |
#8 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 194
Karma: 177180
Join Date: Jun 2009
Location: Mesa, AZ
Device: Sony PRS 505
|
I tried a simple reset a couple of times and it did not work. Thanks for the info about the save to disk...I had a feeling what I did was too simple to be correct.
|
![]() |
![]() |
![]() |
#9 | |
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
|
|
![]() |
![]() |
![]() |
#10 | |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
Using Save to Disk as a backup method has 4 big drawbacks: 1) You have to leave the option "Save Cover Separately" turned on. This option is hidden in Preferences on the 2nd tab of the fifth option down. Otherwise your covers don't get backed up. 2) You have to leave the option "Save Metadata in OPF File" turned on. This option is also hidden in Preferences on the 2nd tab of the fifth option down. Otherwise your metadata doesn't get backed up. 3) Your recipes aren't backed up. 4) It's hard to automate a backup. Problems 1 and 2 can be solved by never turning off those options. However, when you have to constantly use Save to Disk to send to your ereader, as I do, those options are a pain. I could live with the fact that they take up space on my SD card, but the OPF file also produces a file that's the same as the ebook except for extension. My browser on the ereader doesn't show the whole filename, making it hard to pick the ebook instead of the opf file. Problem 3 can be solved by backing up recipes separately, but that's several steps and harder. Problem 4 isn't really solvable AFAICT. It really is much simpler to just copy the entire Library directory. Plus you can do incremental backups, if you wish, using a synchronization program. It will find your new ebook folders, copy those, and detect the fact that the metadata.db file has changed and copy it. It's all automated for me, and I can leave the two "Save" options off and not worry about recipes. Of course, whatever works is fine, but you just have to be more careful. |
|
![]() |
![]() |
![]() |
#11 |
Banned
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 640
Karma: 4911
Join Date: Jul 2007
Location: Grapevine, TX
Device: iPad4
|
I back up both ways. I do a daily incremental like you suggest. My big fear however is that if the database ever gets corrupted, all my data is in that one big, corrupt metadata.db file. I don't like having all my hard work residing in one file. Because my backup is automated daily, the corrupted db file will be backed up too.
I don't have/use recipes so that's not a concern for me. I have over 2500 entries in my database with all the metadata set the way I like it. Too much hard work to trust to a single database file. Last edited by edbro; 05-13-2010 at 08:40 AM. |
![]() |
![]() |
![]() |
#12 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,262
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
The next release of calibre contains code that will try pretty hard to recover from a corrupted database.
Nonetheless, if you feel unsafe, you should use save to disk, as Starson suggested. And a proper backup scheme is one which maintains differentials over at least the past few days/weeks/months Like my backup scheme maintains the last 4 days, the last 4 weeks and the last 3 months. But of course, that sort of thing is probably too hard to set up. |
![]() |
![]() |
![]() |
#13 | |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
I have yet to see a corrupted metadata.db, but if I ever do, I've got all 6 copies backed up every day for months. I didn't mention it, but I also worry about the changes introduced in the beta version. There are lots of new features, user defined fields, saved searches, etc. and much of that stuff is also stored in metadata.db. That file is pretty small and really should get backed up, regardless of whether you also save opf and jpg files separately. |
|
![]() |
![]() |
![]() |
#14 | ||
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
![]() |
||
![]() |
![]() |
![]() |
#15 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Yes. I posted some disadvantages of using Save to Disk as a backup strategy, but there are advantages that I didn't mention (although others did). The principal one is the distributed nature of the metadata storage. Each book stores its own little bit of Calibre-compatible metadata with the book formats. That makes it easy to bring the book back in to Calibre in someone else's Calibre library, or recreate your library from a subset of books.
|
![]() |
![]() |
![]() |
Thread Tools | Search this Thread |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Corrupted files | speakingtohe | Calibre | 2 | 08-20-2010 04:31 PM |
Corrupted Metadata | Marcy | Calibre | 31 | 07-27-2010 10:50 AM |
Corrupted File? | StealthyScribe | Kobo Reader | 8 | 07-21-2010 10:09 PM |
PRS-600 Index corrupted? | CapnKirk | Sony Reader | 0 | 07-10-2010 06:56 PM |
Library corrupted | rozie123 | Sony Reader | 1 | 05-26-2009 07:02 AM |